/* This Source Code Form is subject to the terms of the Mozilla Public
 * License, v. 2.0. If a copy of the MPL was not distributed with this
 * file, You can obtain one at http://mozilla.org/MPL/2.0/. */

var constant_01 = {
    "resultset": [
        //["London", "2010-01-01", 74],
        ["London", "2010-01-02", 1.0],
        ["London", "2010-01-03", 1.0],
        ["London", "2010-01-04", 1.0],
        ["London", "2010-01-05", 1.0],
        ["Paris", "2010-01-01", 1.0],
        ["Paris", "2010-01-02", 1.0],
        //["Paris", "2010-01-03", 9],
        ["Paris", "2010-01-04", 1.0],
        ["Paris", "2010-01-05", 1.0],
        ["Lisbon", "2010-01-01", 1.0],
        ["Lisbon", "2010-01-02", 1.0],
        ["Lisbon", "2010-01-03", 1.0],
        ["Lisbon", "2010-01-04", 1.0]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "Series"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Categories"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "Value"
    }]
};

var constant_02 = {
    "resultset": [
        //["London", "2010-01-01", 74],
        ["London", "2010-01-02", 0.0],
        ["London", "2010-01-03", null],
        ["London", "2010-01-04", 0.0],
        ["London", "2010-01-05", 0.0],
        ["Paris", "2010-01-01", 1.0],
        ["Paris", "2010-01-02", 1.0],
        //["Paris", "2010-01-03", 9],
        ["Paris", "2010-01-04", 1.0],
        ["Paris", "2010-01-05", 1.0],
        ["Lisbon", "2010-01-01", 3.0],
        ["Lisbon", "2010-01-02", 3.1],
        ["Lisbon", "2010-01-03", 3.2],
        ["Lisbon", "2010-01-04", 3.0]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "City"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Date"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "Sales"
    }]
};

var constant_03 = {
    "resultset": [
        //["London", "2010-01-01", 74],
        ["London", "2010-01-02", 0.0],
        ["London", "2010-01-03", 0.0],
        ["London", "2010-01-04", 0.0],
        ["London", "2010-01-05", 0.0],
        ["Paris", "2010-01-01", 0.0],
        ["Paris", "2010-01-02", 0.0],
        //["Paris", "2010-01-03", 9],
        ["Paris", "2010-01-04", 0.0],
        ["Paris", "2010-01-05", 0.0],
        ["Lisbon", "2010-01-01", 0.0],
        ["Lisbon", "2010-01-02", 0.0],
        ["Lisbon", "2010-01-03", 0.0],
        ["Lisbon", "2010-01-04", 0.0]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "City"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Date"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "Sales"
    }]
};


var constant_04 = {
    "resultset": [
        //["London", "2010-01-01", 74],
        ["London", "2010-01-02", -1.0],
        ["London", "2010-01-03", -1.0],
        ["London", "2010-01-04", -1.0],
        ["London", "2010-01-05", -1.0],
        ["Paris", "2010-01-01", -1.0],
        ["Paris", "2010-01-02", -1.0],
        //["Paris", "2010-01-03", 9],
        ["Paris", "2010-01-04", -1.0],
        ["Paris", "2010-01-05", -1.0],
        ["Lisbon", "2010-01-01", -1.0],
        ["Lisbon", "2010-01-02", -1.0],
        ["Lisbon", "2010-01-03", -1.0],
        ["Lisbon", "2010-01-04", -1.0]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "Series"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Categories"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "Value"
    }]
};

var crosstab_01 = {
    "resultset": [["2010-01-01", 73.16494435071945, 43.438252015039325], ["2010-01-02", 53.53385955095291, 83.32914686761796], ["2010-01-03", 5.62654328532517, 2.7900177985429764], ["2010-01-04", 92.91266934014857, 30.821037711575627], ["2010-01-05", 83.33789557218552, 40.18874177709222], ["2010-01-06", 39.970639953389764, 14.558592066168785], ["2010-01-07", 18.367659952491522, 95.70440696552396], ["2010-01-08", 66.07660888694227, 40.77986120246351], ["2010-01-09", 52.848394960165024, 59.28159146569669], ["2010-01-10", 44.47862827219069, 67.15075680986047], ["2010-01-11", 22.86666762083769, 78.885636664927], ["2010-01-12", 61.66831855662167, 25.616485066711903], ["2010-01-13", 25.999347679316998, 86.90497004427016], ["2010-01-14", 33.01921030506492, 30.31503618694842], ["2010-01-15", 48.86134676635265, 24.59320309571922], ["2010-01-16", 5.207635555416346, 22.026291117072105], ["2010-01-17", 68.03145511075854, 58.741495152935386], ["2010-01-18", 5.35543798469007, 73.65799839608371], ["2010-01-19", 61.53151295147836, 98.26810732483864], ["2010-01-20", 4.47903610765934, 44.86940852366388], ["2010-01-21", 38.45684910193086, 44.449676061049104], ["2010-01-22", 59.42800058983266, 56.82450905442238], ["2010-01-23", 40.15408307313919, 25.50460947677493], ["2010-01-24", 97.60437025688589, 93.00247803330421], ["2010-01-25", 84.78620098903775, 42.082998529076576], ["2010-01-26", 60.15323488973081, 7.652868609875441], ["2010-01-27", 20.968635194003582, 21.821553446352482], ["2010-01-28", 33.26935367658734, 46.96798291988671], ["2010-01-29", 8.72652349062264, 66.28856398165226], ["2010-01-30", 77.28301910683513, 57.58787025697529], ["2010-01-31", 90.88176707737148, 82.4906547088176], ["2010-02-01", 79.6141613740474, 58.91322218813002], ["2010-02-02", 41.23214986175299, 84.96959935873747], ["2010-02-03", 32.571220584213734, 2.763662813231349], ["2010-02-04", 83.2377066835761, 37.050256691873074], ["2010-02-05", 47.63307133689523, 21.694555785506964], ["2010-02-06", 81.4999327994883, 7.061071926727891], ["2010-02-07", 78.51906483992934, 21.654015872627497], ["2010-02-08", 32.56568140350282, 76.12343509681523], ["2010-02-09", 14.656493905931711, 17.351882392540574], ["2010-02-10", 18.206433625891805, 74.80972879566252], ["2010-02-11", 25.004751002416015, 39.175068866461515], ["2010-02-12", 96.631282242015, 58.27410472556949], ["2010-02-13", 86.14305178634822, 5.3578057792037725], ["2010-02-14", 24.562668707221746, 63.42607089318335], ["2010-02-15", 62.945676036179066, 15.444435831159353], ["2010-02-16", 45.91672560200095, 42.55983745679259], ["2010-02-17", 74.35765801928937, 87.14887546375394], ["2010-02-18", 27.52943681553006, 6.928878650069237], ["2010-02-19", 89.91253827698529, 10.767143545672297], ["2010-02-20", 43.97913534194231, 37.545609613880515], ["2010-02-21", 32.46169933117926, 25.479068141430616], ["2010-02-22", 44.606681540608406, 10.980764217674732], ["2010-02-23", 53.36302244104445, 71.0350847337395], ["2010-02-24", 77.1830705460161, 21.058505587279797], ["2010-02-25", 25.371988536790013, 70.51326939836144], ["2010-02-26", 76.57933128066361, 4.613912524655461], ["2010-02-27", 21.04827887378633, 59.05872015282512], ["2010-02-28", 37.238977709785104, 81.70248786918819], ["2010-03-01", 35.26365631259978, 80.0496133044362], ["2010-03-02", 75.34930729307234, 12.121202750131488], ["2010-03-03", 50.63879657536745, 6.3281765673309565], ["2010-03-04", 29.13629407994449, 73.14413343556225], ["2010-03-05", 4.693927941843867, 24.206353584304452], ["2010-03-06", 54.576188465580344, 71.13216556608677], ["2010-03-07", 18.255570204928517, 68.98986352607608], ["2010-03-08", 76.73194063827395, 27.662844909355044], ["2010-03-09", 30.106044467538595, 16.01593568921089], ["2010-03-10", 54.98071904294193, 58.54052025824785], ["2010-03-11", 21.168210078030825, 84.48235862888396], ["2010-03-12", 83.0306168179959, 38.08277640491724], ["2010-03-13", 33.578827790915966, 73.46316552720964], ["2010-03-14", 38.00021456554532, 17.88120367564261], ["2010-03-15", 11.189218424260616, 81.19789599440992], ["2010-03-16", 75.43570073321462, 25.62478855252266], ["2010-03-17", 53.06248259730637, 86.54370503500104], ["2010-03-18", 24.625688698142767, 99.66232287697494], ["2010-03-19", 93.09452013112605, 28.42520815320313], ["2010-03-20", 12.085150834172964, 84.34250047430396], ["2010-03-21", 64.80398895218968, 22.82067770138383], ["2010-03-22", 95.8457300439477, 85.80181626603007], ["2010-03-23", 3.4564912784844637, 0.39686616510152817], ["2010-03-24", 44.88377012312412, 22.710973164066672], ["2010-03-25", 89.55065673217177, 73.28446884639561], ["2010-03-26", 56.81951371952891, 71.43195094540715], ["2010-03-27", 22.06684066914022, 43.76947875134647], ["2010-03-28", 14.922645268961787, 43.797738244757056], ["2010-03-29", 33.39884500019252, 76.04586347006261], ["2010-03-30", 43.11511958949268, 2.8281989507377148], ["2010-03-31", 52.16162302531302, 25.500226113945246], ["2010-04-01", 68.66250135935843, 56.09547677449882], ["2010-04-02", 18.46442688256502, 14.949401700869203], ["2010-04-03", 2.8004196006804705, 31.82840272784233], ["2010-04-04", 97.79879543930292, 29.239610256627202], ["2010-04-05", 23.15835482440889, 39.15575533173978], ["2010-04-06", 57.376608066260815, 2.9605682939291], ["2010-04-07", 16.054365690797567, 98.22947378270328], ["2010-04-08", 99.89029546268284, 66.81860024109483], ["2010-04-09", 87.48265258036554, 18.97650398313999], ["2010-04-10", 47.13308401405811, 77.17236299067736], ["2010-04-11", 87.10419931448996, 61.78957796655595], ["2010-04-12", 94.52424538321793, 5.310632986947894], ["2010-04-13", 36.599306762218475, 19.528996432200074], ["2010-04-14", 44.48570185340941, 33.23058905079961], ["2010-04-15", 77.80310115776956, 30.628753639757633], ["2010-04-16", 38.58839483000338, 2.3657698649913073], ["2010-04-17", 94.05482453294098, 1.5340708661824465], ["2010-04-18", 17.81020569615066, 39.971550181508064], ["2010-04-19", 44.09390832297504, 92.16786376200616], ["2010-04-20", 27.120425645262003, 71.62334518507123], ["2010-04-21", 99.0967424120754, 17.03296396881342], ["2010-04-22", 82.39048873074353, 43.07587775401771], ["2010-04-23", 54.578573582693934, 14.852188061922789], ["2010-04-24", 68.55494594201446, 99.18525516986847], ["2010-04-25", 25.83295227959752, 15.688029956072569], ["2010-04-26", 76.35761816054583, 12.93715164065361], ["2010-04-27", 77.47760792262852, 70.88186354376376], ["2010-04-28", 18.247784627601504, 14.076914731413126], ["2010-04-29", 90.41085997596383, 62.733486481010914], ["2010-04-30", 47.307503782212734, 68.21396113373339], ["2010-05-01", 93.36224012076855, 85.89589861221611], ["2010-05-02", 70.57973104529083, 87.41706465370953], ["2010-05-03", 87.42996947839856, 88.38993674144149], ["2010-05-04", 27.388614835217595, 31.52387784793973], ["2010-05-05", 80.55780050344765, 54.50904052704573], ["2010-05-06", 3.1472230330109596, 79.65454291552305], ["2010-05-07", 71.54200449585915, 85.53771176375449], ["2010-05-08", 22.73042071610689, 26.12057807855308], ["2010-05-09", 0.38989982567727566, 91.28536665812135], ["2010-05-10", 25.30583324842155, 26.222852151840925], ["2010-05-11", 6.973396614193916, 1.6634514089673758], ["2010-05-12", 39.160003792494535, 84.45100458338857], ["2010-05-13", 72.54531499929726, 57.40778842009604], ["2010-05-14", 98.5279193148017, 62.95617497526109], ["2010-05-15", 20.141274901106954, 45.83542309701443], ["2010-05-16", 31.170136155560613, 13.5035150218755], ["2010-05-17", 31.731321709230542, 1.7498672008514404], ["2010-05-18", 0.9205796755850315, 19.161291187629104], ["2010-05-19", 90.13980394229293, 28.309194557368755], ["2010-05-20", 50.68516903556883, 70.69760449230671], ["2010-05-21", 82.81823508441448, 53.83239206857979], ["2010-05-22", 50.35214740782976, 54.36023958027363], ["2010-05-23", 39.37010383233428, 73.08256812393665], ["2010-05-24", 80.48081765882671, 39.760003704577684], ["2010-05-25", 64.367934782058, 5.786650953814387], ["2010-05-26", 65.98285585641861, 71.34133144281805], ["2010-05-27", 7.450102362781763, 5.142859648913145], ["2010-05-28", 55.79233602620661, 79.99541736207902], ["2010-05-29", 62.550648069009185, 54.320255341008306], ["2010-05-30", 42.951592383906245, 82.69192297011614], ["2010-05-31", 0.15567843802273273, 74.12172853946686], ["2010-06-01", 96.19543799199164, 31.887000147253275], ["2010-06-02", 75.8715957403183, 97.11601766757667], ["2010-06-03", 51.04829133488238, 66.01139968261123], ["2010-06-04", 25.425212224945426, 1.7334604170173407], ["2010-06-05", 36.709004174917936, 8.243447309359908], ["2010-06-06", 55.565852485597134, 87.06115162931383], ["2010-06-07", 62.603686889633536, 94.93595636449754], ["2010-06-08", 60.14371975325048, 43.084504595026374], ["2010-06-09", 34.69596006907523, 24.51165458187461], ["2010-06-10", 48.87115554884076, 0.6788159254938364], ["2010-06-11", 95.85298602469265, 56.321257911622524], ["2010-06-12", 5.8216755744069815, 51.64532205089927], ["2010-06-13", 36.31667532026768, 68.37232364341617], ["2010-06-14", 5.965577391907573, 79.26826770417392], ["2010-06-15", 51.064246613532305, 6.1212558299303055], ["2010-06-16", 53.38999624364078, 47.259684605523944], ["2010-06-17", 38.00825597718358, 29.26159198395908], ["2010-06-18", 44.375702273100615, 89.05654731206596], ["2010-06-19", 95.2729916665703, 69.80091454461217], ["2010-06-20", 90.7900077290833, 31.98199588805437], ["2010-06-21", 78.04436185397208, 46.35586026124656], ["2010-06-22", 19.043147517368197, 40.64804879017174], ["2010-06-23", 41.291816625744104, 79.18686727061868], ["2010-06-24", 83.73255338519812, 75.98777669481933], ["2010-06-25", 3.698521852493286, 32.60370893403888], ["2010-06-26", 76.66659262031317, 99.55150787718594], ["2010-06-27", 88.9249668456614, 82.48826819472015], ["2010-06-28", 51.19682992808521, 25.24164216592908], ["2010-06-29", 50.860591838136315, 57.16240731999278], ["2010-06-30", 4.509909870103002, 1.92483845166862], ["2010-07-01", 63.283663149923086, 57.89990611374378], ["2010-07-02", 49.184523057192564, 1.2919191271066666], ["2010-07-03", 87.16149809770286, 93.56022533029318], ["2010-07-04", 90.34846648573875, 82.4344898108393], ["2010-07-05", 63.36113987490535, 81.13847421482205], ["2010-07-06", 14.416485698893666, 41.405501775443554], ["2010-07-07", 27.494334476068616, 33.459633216261864], ["2010-07-08", 82.0535505656153, 68.78615110181272], ["2010-07-09", 12.64650048688054, 65.78610395081341], ["2010-07-10", 44.77392779663205, 16.345022385939956], ["2010-07-11", 98.38981288485229, 21.44052041694522], ["2010-07-12", 15.896530263125896, 87.31477973051369], ["2010-07-13", 3.928788611665368, 67.09336023777723], ["2010-07-14", 12.5564219430089, 54.78938044980168], ["2010-07-15", 24.255767557770014, 17.0663318131119], ["2010-07-16", 56.7142189014703, 87.53943075425923], ["2010-07-17", 74.96623797342181, 5.8987419586628675], ["2010-07-18", 88.8313498813659, 62.12773607112467], ["2010-07-19", 99.45896733552217, 79.17981636710465], ["2010-07-20", 44.56222588196397, 62.82010721042752], ["2010-07-21", 60.31829062849283, 58.978711580857635], ["2010-07-22", 4.225608985871077, 87.81262510456145], ["2010-07-23", 92.4383447971195, 86.27915955148637], ["2010-07-24", 56.5987762529403, 5.084845330566168], ["2010-07-25", 52.065263502299786, 1.3727040495723486], ["2010-07-26", 21.429867716506124, 50.455076387152076], ["2010-07-27", 22.813224513083696, 37.32639797963202], ["2010-07-28", 37.769856164231896, 26.742013124749064], ["2010-07-29", 4.419758217409253, 50.326278107240796], ["2010-07-30", 81.53139362111688, 28.675525821745396], ["2010-07-31", 67.3926099203527, 38.24561252258718], ["2010-08-01", 16.214956576004624, 42.35884789377451], ["2010-08-02", 44.144354527816176, 5.04630645737052], ["2010-08-03", 4.486584011465311, 43.60332186333835], ["2010-08-04", 84.2261228710413, 49.04880989342928], ["2010-08-05", 6.423429073765874, 44.54441349953413], ["2010-08-06", 8.027521520853043, 10.64903810620308], ["2010-08-07", 32.35703860409558, 0.46586631797254086], ["2010-08-08", 96.92819765768945, 88.95581485703588], ["2010-08-09", 5.550711648538709, 48.99346120655537], ["2010-08-10", 90.32851895317435, 26.980579365044832], ["2010-08-11", 99.44853759370744, 13.141743466258049], ["2010-08-12", 64.30697739124298, 37.21839375793934], ["2010-08-13", 39.88375659100711, 68.72673560865223], ["2010-08-14", 87.54467186518013, 21.41515021212399], ["2010-08-15", 97.40226143039763, 54.93728183209896], ["2010-08-16", 59.6607627812773, 13.617218006402254], ["2010-08-17", 97.29612972587347, 3.8051173090934753], ["2010-08-18", 18.663524510338902, 1.7827137373387814], ["2010-08-19", 47.40843917243183, 2.8896473813802004], ["2010-08-20", 50.83152367733419, 53.8318682461977], ["2010-08-21", 47.43406088091433, 58.85904519818723], ["2010-08-22", 64.48090635240078, 79.79109948500991], ["2010-08-23", 59.32491151615977, 61.40910405665636], ["2010-08-24", 68.74691438861191, 64.87562321126461], ["2010-08-25", 10.402565263211727, 59.075433341786265], ["2010-08-26", 91.85620257630944, 9.85110285691917], ["2010-08-27", 72.21717680804431, 56.16317996755242], ["2010-08-28", 47.06949666142464, 12.100933399051428], ["2010-08-29", 24.889915622770786, 34.61416852660477], ["2010-08-30", 33.51608365774155, 22.292177053168416], ["2010-08-31", 89.55145035870373, 93.17684643901885], ["2010-09-01", 35.9093951061368, 86.84758013114333], ["2010-09-02", 96.98196374811232, 54.5729196164757], ["2010-09-03", 88.63029386848211, 44.39040292054415], ["2010-09-04", 57.4625669978559, 39.4618175458163], ["2010-09-05", 98.22227116674185, 4.896627878770232], ["2010-09-06", 98.32086274400353, 62.703177565708756], ["2010-09-07", 84.68772736378014, 57.645774306729436], ["2010-09-08", 24.112281622365117, 53.434641752392054], ["2010-09-09", 22.521397517994046, 34.514846885576844], ["2010-09-10", 12.510075094178319, 14.377600094303489], ["2010-09-11", 44.365949742496014, 84.72725190222263], ["2010-09-12", 70.54078010842204, 91.43544640392065], ["2010-09-13", 96.82818534784019, 95.43069573119283], ["2010-09-14", 26.04961497709155, 30.344269005581737], ["2010-09-15", 17.722872784361243, 15.601065335795283], ["2010-09-16", 23.521115444600582, 53.63226789049804], ["2010-09-17", 2.448645466938615, 20.503079192712903], ["2010-09-18", 8.205187506973743, 91.07893938198686], ["2010-09-19", 64.89348211325705, 65.66775450482965], ["2010-09-20", 30.54075692780316, 63.1157532799989], ["2010-09-21", 70.56438238359988, 28.861619718372822], ["2010-09-22", 25.818930845707655, 55.25210979394615], ["2010-09-23", 86.50739402510226, 49.93121246807277], ["2010-09-24", 8.6867515463382, 9.028791543096304], ["2010-09-25", 84.44605935364962, 21.19682668708265], ["2010-09-26", 23.406391637399793, 28.81200914271176], ["2010-09-27", 5.924078589305282, 93.94717174582183]],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "date"
    }, {
        "colIndex": 1,
        "colType": "Numeric",
        "colName": "value1"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "value2"
    }]
};

var crosstab_02 = {
    "resultset": [
        ["2011-01", null, 367, 24, null, 11, null, 11305],
        ["2011-02", null, 131, 62, null, 81, null, 13815],
        ["2011-03", null, 421, 165, 6, 200, null, 15864],
        ["2011-04", null, 114, 512, null, 504, 4, 14870],
        ["2011-05", null, 79, 441, null, 832, null, 15289],
        ["2011-06", null, 32, 516, 28, 1494, null, 20592],
        ["2011-07", null, null, 568, 1, 1346, null, 15753],
        ["2011-08", null, 1, 591, 2, 1136, null, 12215],
        ["2011-09", null, 1, 525, 112, 2606, null, 22836],
        ["2011-10", null, 30, 365, 16, 1323, 1, 18231],
        ["2011-11", 7, 2, 330, 93, 1351, 2, 22820],
        ["2011-12", 220, 1, 425, 142, 5942, 1, 15844]
    ],
    "metadata": [
        {
            "colIndex": 0,
            "colType": "String",
            "colName": "Year_Month"
        },
        {
            "colIndex": 1,
            "colType": "String",
            "colName": "Qty/AUS"
        },
        {
            "colIndex": 2,
            "colType": "Numeric",
            "colName": "Qty/CAM"
        },
        {
            "colIndex": 3,
            "colType": "Numeric",
            "colName": "Qty/RCM"
        },
        {
            "colIndex": 4,
            "colType": "String",
            "colName": "Qty/RCN"
        },
        {
            "colIndex": 5,
            "colType": "Numeric",
            "colName": "Qty/RNA"
        },
        {
            "colIndex": 6,
            "colType": "String",
            "colName": "Qty/SGP"
        },
        {
            "colIndex": 7,
            "colType": "Numeric",
            "colName": "Qty/VNO"
        }
    ]
};

var relational_01a = {
    "resultset": [
        //["London", "2010-01-01", 74],
        ["London", "2011-06-05", 72],
        ["London", "2011-06-12", 50],
        ["London", "2011-06-19", 20],
        ["London", "2011-06-26", 23],
        ["London", "2011-07-03", 72],
        ["London", "2011-07-10", 80],
        //["London", "2011-07-17", 20],
        ["London", "2011-07-26", 23],
        ["London", "2011-07-31", 72],
        ["London", "2011-08-07", 50],
        ["London", "2011-08-14", 20],
        //["London", "2011-08-21", 23],
        ["London", "2011-08-28", 20],
        //
        ["Paris", "2011-06-05", 27],
        //["Paris", "2011-06-12", 5],
        //["Paris", "2011-06-19", 2],
        ["Paris", "2011-06-26", 32],
        ["Paris", "2011-07-03", 24],
        ["Paris", "2011-07-10", 80],
        ["Paris", "2011-07-17", 90],
        ["Paris", "2011-07-24", 53],
        ["Paris", "2011-07-31", 17],
        ["Paris", "2011-08-07", 20],
        //["Paris", "2011-08-14", 0],
        ["Paris", "2011-08-21", 43],
        //["Paris", "2011-08-28", 40],
        //
        ["Lisbon", "2011-06-12", 30],
        ["Lisbon", "2011-07-03", 60],
        ["Lisbon", "2011-07-10", 80],
        ["Lisbon", "2011-07-17", 15]//,
       // ["Lisbon", "2011-07-24", 3]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "City"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Date"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "Quantity"
    }]
};

var relational_01b = {
    "resultset": [
        ["London", "2011-06-05", 72],
        ["London", "2011-06-12", 50],
        ["London", "2011-06-19", 20],
        ["London", "2011-06-26", 23],
        ["London", "2011-07-03", 72],
        ["London", "2011-07-10", 50],
        ["London", "2011-07-17", 20],
        ["London", "2011-07-24", 23],
        ["London", "2011-07-31", 72],
        ["London", "2011-08-07", 50],
        ["London", "2011-08-14", 20],
        ["London", "2011-08-21", 23],
        ["London", "2011-08-28", 20],
        //
        ["Paris", "2011-06-05", 27],
        ["Paris", "2011-06-12", 5],
        ["Paris", "2011-06-19", 2],
        ["Paris", "2011-06-26", 32],
        ["Paris", "2011-07-03", 24],
        ["Paris", "2011-07-10", 4],
        ["Paris", "2011-07-17", 90],
        ["Paris", "2011-07-24", 53],
        ["Paris", "2011-07-31", 17],
        ["Paris", "2011-08-07", 20],
        ["Paris", "2011-08-14", 2],
        ["Paris", "2011-08-21", 43],
        ["Paris", "2011-08-28", 40],
        //
        ["Lisbon", "2011-07-03", 60],
        ["Lisbon", "2011-07-10", 40],
        ["Lisbon", "2011-07-17", 15],
        ["Lisbon", "2011-07-24", 3]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "City"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Date"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "Quantity"
    }]
};

var relational_01c = {
    "resultset": [
        ["London", "2011-06-05", 72, 60, 80, 55, 85],
        ["London", "2011-06-12", 50, 45, 55, 42, 59],
        ["London", "2011-06-19", 20, 18, 25, 10, 40],
        ["London", "2011-06-26", 23, 20, 30, -8, 37],
        ["London", "2011-07-03", 72, 60, 90, 50, 97],
        ["London", "2011-07-10", 50, 47, 57, 41, 63],
        ["London", "2011-07-17", 20,  2, 50,-10, 75],
        ["London", "2011-07-24", 23, 18, 25, 13, 34],
        //
        ["Paris", "2011-06-05",  27, 25, 36, 10, 41],
        ["Paris", "2011-06-12",   5,  4,  8,  2, 13],
        ["Paris", "2011-06-19",   2, -3, 10,-20, 17],
        ["Paris", "2011-06-26", -32, -40, -20, -56, -15],
        ["Paris", "2011-07-03",  24, 21, 31, 18, 35],
        ["Paris", "2011-07-10",  30, 20, 35, null, null],
        ["Paris", "2011-07-17",  90, null, null, 67, 105],
        ["Paris", "2011-07-24",  53, 30, null, 23, 70],
        //
        ["Lisbon", "2011-07-03",  6, null, 10, 2, null],
        ["Lisbon", "2011-07-10",  4,  2,  9, null, 12],
        ["Lisbon", "2011-07-17",  1,  0,  5, -5,  null],
        ["Lisbon", "2011-07-24",  3, -2, null, -10, null]
    ],
    "metadata": [{
        "colType": "String",
        "colName": "City"
    }, {
        "colType": "String",
        "colName": "Day"
    }, {
        "colType": "Numeric",
        "colName": "Sales"
    }, {
        "colType": "Numeric",
        "colName": "p25"
    }, {
        "colType": "Numeric",
        "colName": "p75"
    }, {
        "colType": "Numeric",
        "colName": "p5"
    }, {
        "colType": "Numeric",
        "colName": "p95"
    }]
};

var relational_01d = {
    "resultset": [
        ["2011-06-05", 72, 60, 80, 55, 85],
        ["2011-06-12", 50, 45, 55, 42, 59],
        ["2011-06-19", 20, 18, 25, 10, 40],
        ["2011-06-26", 23, 20, 30, -8, 37],
        ["2011-07-03", 72, 60, 90, 50, 97],
        ["2011-07-10", 50, 47, 57, 41, 63],
        ["2011-07-17", 20,  2, 50,-10, 75],
        ["2011-07-24", 23, 18, 25, 13, 34]
    ],
    "metadata": [{
        "colType": "String",
        "colName": "Day"
    }, {
        "colType": "Numeric",
        "colName": "Sales"
    }, {
        "colType": "Numeric",
        "colName": "p25"
    }, {
        "colType": "Numeric",
        "colName": "p75"
    }, {
        "colType": "Numeric",
        "colName": "p5"
    }, {
        "colType": "Numeric",
        "colName": "p95"
    }]
};

var relational_01 = relational_01a;

var relational_01_neg = {
    "resultset": [
        ["London", "2011-06-05", -72],
        ["London", "2011-06-12", -50],
        ["London", "2011-06-19", -20],
        ["London", "2011-06-26", -23],
        ["London", "2011-07-03", -72],
        ["London", "2011-07-10", 50],
        ["London", "2011-07-17", 30],
        ["London", "2011-07-24", -23],
        ["London", "2011-07-31", -72],
        ["London", "2011-08-07", -50],
        ["London", "2011-08-14", 100],
        ["London", "2011-08-21", -23],
        ["London", "2011-08-28", -20],
        //
        ["Paris", "2011-06-05", 27],
        ["Paris", "2011-06-12", 5],
        ["Paris", "2011-06-19", 2],
        ["Paris", "2011-06-26", 32],
        ["Paris", "2011-07-03", 24],
        ["Paris", "2011-07-10", 4],
        ["Paris", "2011-07-17", 105],
        ["Paris", "2011-07-24", 53],
        ["Paris", "2011-07-31", 17],
        ["Paris", "2011-08-07", 20],
        ["Paris", "2011-08-14", -40],
        ["Paris", "2011-08-21", 43],
        ["Paris", "2011-08-28", 40],
        //
        ["Lisbon", "2011-07-03", 60],
        ["Lisbon", "2011-07-10", 40],
        ["Lisbon", "2011-07-17", 105],
        ["Lisbon", "2011-07-24", -30],
        ["Lisbon", "2011-08-07", 50]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "City"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Date"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "Profit"
    }]
};

//pvcTestRealTimeBar
var relational_RT_Bar = {
    "resultset": [
        ["London", 1, "2011-07-17"],
        ["London", 2, "2011-08-21"],
        ["London", 4, "2011-08-28"],
        //
        ["Paris", 2, "2011-07-05"],
        ["Paris", 2, "2011-08-21"],
        ["Paris", 1, "2011-08-28"],
        //
        ["Lisbon", 1, "2011-07-03"],
        ["Lisbon", 2, "2011-07-24"],
        ["Lisbon", 1, "2011-08-07"]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "City"
    }, {
        "colIndex": 1,
        "colType": "Numeric",
        "colName": "Profit"
    }, {
        "colIndex": 2,
        "colType": "String",
        "colName": "Date"
    }]
};

//pvcTestRealTimeLine
var relational_RT_Line = {
    "resultset": [
        ["London", "2011-07-05", -7],
        ["London", "2011-07-12", -5],
        ["London", "2011-07-19", -2],
        ["London", "2011-07-26", -2],
        ["London", "2011-08-03", -7],
        ["London", "2011-08-10", 5],
        ["London", "2011-08-17", 3],
        ["London", "2011-08-24", -2],
        ["London", "2011-08-31", -7],
        //
        ["Paris", "2011-07-05", 2],
        ["Paris", "2011-07-12", 5],
        ["Paris", "2011-07-19", 2],
        ["Paris", "2011-07-26", 3],
        ["Paris", "2011-08-03", 2],
        ["Paris", "2011-08-10", 4],
        ["Paris", "2011-08-17", 1],
        ["Paris", "2011-08-24", 5],
        ["Paris", "2011-08-31", 1],
        //
        ["Lisbon", "2011-07-03", 6],
        ["Lisbon", "2011-07-10", 4],
        ["Lisbon", "2011-08-17", 1],

    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "City"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Date"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "Profit"
    }]
};

//pvcTestRealTimeNew
var relational_RT_Likes = {
    "resultset": [
        ["Post1", "2011-07-05", 1],
        ["Post1", "2011-07-12", 1],
        ["Post1", "2011-07-19", 1],
        ["Post1", "2011-07-26", 1],
        //
        ["Page", "2011-07-05", 1],
        ["Page", "2011-07-12", 1],
        ["Page", "2011-07-19", 1],
        ["Page", "2011-07-26", 1],
        ["Page", "2011-08-03", 1],
        ["Page", "2011-08-10", 1],

    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "City"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Date"
    }, {
        "colIndex": 2,
        "colType": "Number",
        "colName": "Value"
    }]
};

var relational_01_2measures_neg = {
    "resultset": [
        ["London", "2011-06-05", -72, 1000],
        ["London", "2011-06-12", -50,  444],
        ["London", "2011-06-19", -20,  100],
        ["London", "2011-06-26", -23,  319],
        ["London", "2011-07-03", -72,  100],
        ["London", "2011-07-10", 50,  1000],
        ["London", "2011-07-17", 30,    98],
        ["London", "2011-07-24", -23,    5],
        ["London", "2011-07-31", -72,  721],
        ["London", "2011-08-07", -50,   99],
        ["London", "2011-08-14", 100,   12],
        ["London", "2011-08-21", -23,  200],
        ["London", "2011-08-28", -20,  150],
        //
        ["Paris", "2011-06-05", 27, 121],
        ["Paris", "2011-06-12", 5,  222],
        ["Paris", "2011-06-19", 2,  333],
        ["Paris", "2011-06-26", 32, 678],
        ["Paris", "2011-07-03", 24, 412],
        ["Paris", "2011-07-10", 4,   10],
        ["Paris", "2011-07-17", 105, 90],
        ["Paris", "2011-07-24", 53, 100],
        ["Paris", "2011-07-31", 17, 400],
        ["Paris", "2011-08-07", 20, 200],
        ["Paris", "2011-08-14", -40, 90],
        ["Paris", "2011-08-21", 43, 100],
        ["Paris", "2011-08-28", 40, 240],
        //
        ["Lisbon", "2011-07-03", 60, 230],
        ["Lisbon", "2011-07-10", 40, 260],
        ["Lisbon", "2011-07-17", 105,100],
        ["Lisbon", "2011-07-24", -30, 90],
        ["Lisbon", "2011-08-07", 50,  32]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "City"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Date"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "Profit"
    }, {
        "colIndex": 3,
        "colType": "Numeric",
        "colName": "Sales"
    }]
};

var relational_01_2measures_pos = {
    "resultset": [
        ["London", "2011-06-05", 72, 1000],
        ["London", "2011-06-12", 50,  444],
        ["London", "2011-06-19", 20,  100],
        ["London", "2011-06-26", 23,  319],
        ["London", "2011-07-03", 72,  100],
        ["London", "2011-07-10", 50,  1000],
        ["London", "2011-07-17", 30,    98],
        ["London", "2011-07-24", 23,    5],
        ["London", "2011-07-31", 72,  721],
        ["London", "2011-08-07", 50,   99],
        ["London", "2011-08-14", 100,   12],
        ["London", "2011-08-21", 23,  200],
        ["London", "2011-08-28", 20,  150],
        //
        ["Paris", "2011-06-05", 27, 121],
        ["Paris", "2011-06-12", 5,  222],
        ["Paris", "2011-06-19", 2,  333],
        ["Paris", "2011-06-26", 32, 678],
        ["Paris", "2011-07-03", 24, 412],
        ["Paris", "2011-07-10", 4,   10],
        ["Paris", "2011-07-17", 105, 90],
        ["Paris", "2011-07-24", 53, 100],
        ["Paris", "2011-07-31", 17, 400],
        ["Paris", "2011-08-07", 20, 200],
        ["Paris", "2011-08-14", 40, 90],
        ["Paris", "2011-08-21", 43, 100],
        ["Paris", "2011-08-28", 40, 240],
        //
        ["Lisbon", "2011-07-03", 60, 230],
        ["Lisbon", "2011-07-10", 40, 260],
        ["Lisbon", "2011-07-17", 105,100],
        ["Lisbon", "2011-07-24", 30, 90],
        ["Lisbon", "2011-08-07", 50,  32]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "City"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Date"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "Profit"
    }, {
        "colIndex": 3,
        "colType": "Numeric",
        "colName": "Sales"
    }]
};

var relational_01_2measures_costs_sales = {
    "resultset": [
        ["London", "2011-06-05", -72, 1000],
        ["London", "2011-06-12", -50,  444],
        ["London", "2011-06-19", -20,  100],
        ["London", "2011-06-26", -23,  319],
        ["London", "2011-07-03", -72,  100],
        ["London", "2011-07-10", -50,  1000],
        ["London", "2011-07-17", -30,    98],
        ["London", "2011-07-24", -23,    5],
        ["London", "2011-07-31", -72,  721],
        ["London", "2011-08-07", -50,   99],
        ["London", "2011-08-14", -100,   12],
        ["London", "2011-08-21", -23,  200],
        ["London", "2011-08-28", -20,  150],
        //
        ["Paris", "2011-06-05", -27, 121],
        ["Paris", "2011-06-12", -5,  222],
        ["Paris", "2011-06-19", -2,  333],
        ["Paris", "2011-06-26", -32, 678],
        ["Paris", "2011-07-03", -24, 412],
        ["Paris", "2011-07-10", -4,   10],
        ["Paris", "2011-07-17", -105, 90],
        ["Paris", "2011-07-24", -53, 100],
        ["Paris", "2011-07-31", -17, 400],
        ["Paris", "2011-08-07", -20, 200],
        ["Paris", "2011-08-14", -40, 90],
        ["Paris", "2011-08-21", -43, 100],
        ["Paris", "2011-08-28", -40, 240],
        //
        ["Lisbon", "2011-07-03", -60, 230],
        ["Lisbon", "2011-07-10", -40, 260],
        ["Lisbon", "2011-07-17", -105,100],
        ["Lisbon", "2011-07-24", -30, 90],
        ["Lisbon", "2011-08-07", -50,  32]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "City"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Date"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "Costs"
    }, {
        "colIndex": 3,
        "colType": "Numeric",
        "colName": "Sales"
    }]
};

var relational_01_2measures_costs_sales_pos = {
    "resultset": [
        ["London", "2011-06-05", 72, 1000],
        ["London", "2011-06-12", 50,  444],
        ["London", "2011-06-19", 20,  100],
        ["London", "2011-06-26", 23,  319],
        ["London", "2011-07-03", 72,  100],
        ["London", "2011-07-10", 50,  1000],
        ["London", "2011-07-17", 30,    98],
        ["London", "2011-07-24", 23,    5],
        ["London", "2011-07-31", 72,  721],
        ["London", "2011-08-07", 50,   99],
        ["London", "2011-08-14", 100,   12],
        ["London", "2011-08-21", 23,  200],
        ["London", "2011-08-28", 20,  150],
        //
        ["Paris", "2011-06-05", 27, 121],
        ["Paris", "2011-06-12", 5,  222],
        ["Paris", "2011-06-19", 2,  333],
        ["Paris", "2011-06-26", 32, 678],
        ["Paris", "2011-07-03", 24, 412],
        ["Paris", "2011-07-10", 4,   10],
        ["Paris", "2011-07-17", 105, 90],
        ["Paris", "2011-07-24", 53, 100],
        ["Paris", "2011-07-31", 17, 400],
        ["Paris", "2011-08-07", 20, 200],
        ["Paris", "2011-08-14", 40, 90],
        ["Paris", "2011-08-21", 43, 100],
        ["Paris", "2011-08-28", 40, 240],
        //
        ["Lisbon", "2011-07-03", 60, 230],
        ["Lisbon", "2011-07-10", 40, 260],
        ["Lisbon", "2011-07-17", 105,100],
        ["Lisbon", "2011-07-24", 30, 90],
        ["Lisbon", "2011-08-07", 50,  32]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "City"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Date"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "Costs"
    }, {
        "colIndex": 3,
        "colType": "Numeric",
        "colName": "Sales"
    }]
};

var relational_01_2measures_currency = {
    "resultset": [
        ["London", "2011-06-05", 1100, 1000],
        ["London", "2011-06-12", 500,  444],
        ["London", "2011-06-19", 120,  100],
        ["London", "2011-06-26", 400,  319],
        ["London", "2011-07-03", 120,  100],
        ["London", "2011-07-10", 1200, 1000],
        ["London", "2011-07-17", 120,    98],
        ["London", "2011-07-24", 9,    5],
        ["London", "2011-07-31", 852,  721],
        //
        ["Paris", "2011-06-05", 132, 121],
        ["Paris", "2011-06-12", 230,  222],
        ["Paris", "2011-06-19", 350,  333],
        ["Paris", "2011-06-26", 734, 678],
        ["Paris", "2011-07-03", 502, 412],
        ["Paris", "2011-07-10", 17,   10],
        ["Paris", "2011-07-17", 115, 90],
        ["Paris", "2011-07-24", 132, 100],
        ["Paris", "2011-07-31", 430, 400],
        //
        ["Lisbon", "2011-07-03", 253, 230],
        ["Lisbon", "2011-07-10", 300, 260],
        ["Lisbon", "2011-07-17", 105,100],
        ["Lisbon", "2011-07-24", 110, 90]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "City"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Date"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "Sales EUR"
    }, {
        "colIndex": 3,
        "colType": "Numeric",
        "colName": "Sales USD"
    }]
};

var relational_01_all_neg = {
    "resultset": [
        ["London", "2011-06-05", -72],
        ["London", "2011-06-12", -50],
        ["London", "2011-06-19", -20],
        ["London", "2011-06-26", -23],
        ["London", "2011-07-03", -72],
        ["London", "2011-07-10", -50],
        ["London", "2011-07-17", -30],
        ["London", "2011-07-24", -23],
        ["London", "2011-07-31", -72],
        ["London", "2011-08-07", -50],
        ["London", "2011-08-14", -100],
        ["London", "2011-08-21", -23],
        ["London", "2011-08-28", -20],
        //
        ["Paris", "2011-06-05", -27],
        ["Paris", "2011-06-26", -32],
        ["Paris", "2011-07-03", -24],
        ["Paris", "2011-07-17", -105],
        ["Paris", "2011-07-24", -53],
        ["Paris", "2011-07-31", -17],
        ["Paris", "2011-08-07", -20],
        ["Paris", "2011-08-14", -40],
        ["Paris", "2011-08-21", -43],
        ["Paris", "2011-08-28", -40],
        //
        ["Lisbon", "2011-07-03", -60],
        ["Lisbon", "2011-07-10", -40],
        ["Lisbon", "2011-07-17", -105],
        ["Lisbon", "2011-07-24", -30],
        ["Lisbon", "2011-08-07", -50]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "City"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Date"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "Profit"
    }]
};

var relational_012 = {
    "resultset": [
        ["London", "2011-07-03", 72],
        ["London", "2011-07-10", 50],
        ["London", "2011-07-17", 20],
        ["London", "2011-07-24", 23],
        ["London", "2011-07-31", 72],
        ["London", "2011-08-02", 50],

        ["Lisbon", "2011-07-03", 60],
        ["Lisbon", "2011-07-10", 40],
        ["Lisbon", "2011-07-17", 15],
        ["Lisbon", "2011-07-24", 3]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "City"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Date"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "Quantity"
    }]
};

var relational_013 = {
    "resultset": [
        ["London", "2011-07-03", 72],
        ["London", "2011-07-10", 50],
        ["London", "2011-07-17", 20],
        ["London", "2011-07-24", 23],
        ["London", "2011-07-31", 72],
        ["London", "2011-08-02", 50],

        ["Lisbon", "2011-07-03", 60],
        ["Lisbon", "2011-07-10", 40],
        ["Lisbon", "2011-07-17", 15],
        ["Lisbon", "2011-07-24", 3],
        ["Lisbon", "2011-09-30", 30]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "City"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Date"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "Value"
    }]
};

var relationalCitiesDaily = {
    "resultset": [
        ["London", "2011-06-05", 72],
        ["London", "2011-06-06", 50],
        ["London", "2011-06-07", 20],
        ["London", "2011-06-08", 23],
        ["London", "2011-06-09", 72],
        ["London", "2011-06-10", 80],
        ["London", "2011-06-11", 20],
        ["London", "2011-06-12", 23],
        ["London", "2011-06-13", 72],
        ["London", "2011-06-14", 50],
        ["London", "2011-06-15", 20],
        ["London", "2011-06-16", 23],
        ["London", "2011-06-17", 20],

        ["Paris",  "2011-06-05", 27],
        ["Paris",  "2011-06-06",  5],
        ["Paris",  "2011-06-07",  2],
        ["Paris",  "2011-06-08", 32],
        ["Paris",  "2011-07-09", 24],
        ["Paris",  "2011-07-10", 80],
        ["Paris",  "2011-07-11", 90],
        ["Paris",  "2011-07-12", 53],
        ["Paris",  "2011-07-13", 17],
        ["Paris",  "2011-07-14", 20],
        ["Paris",  "2011-07-15",  0],
        ["Paris",  "2011-07-16", 43],
        ["Paris",  "2011-08-17", 40],

        ["Lisbon", "2011-06-11", 30],
        ["Lisbon", "2011-06-12", 60],
        ["Lisbon", "2011-06-14", 80],
        ["Lisbon", "2011-06-16", 15],
        ["Lisbon", "2011-06-17",  3]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "City"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Date"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "Quantity"
    }]
};

var relational_test = {
    "resultset": [["Infrastructure Security", 3]],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "name"
    }, {
        "colIndex": 1,
        "colType": "Integer",
        "colName": "value"
    }]
};

var relational_02 = {
    "resultset": [
        ["London", 74],
        ["Paris", 48],
        ["Lisbon", 37],
        ["Sydney", 27],
        ["Athens", 22],
        ["Beijing", 19],
        ["Ottawa", 18],
        ["Prague", 4]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "City"
    }, {
        "colIndex": 1,
        "colType": "Numeric",
        "colName": "Value"
    }]
};

var relational_03 = {
    "resultset": [
        ["London", 74],
        ["Paris", 48],
        ["New York", 37],
        ["Prague", 27],
        ["Stockholm", 22],
        ["Sydney", 19],
        ["Madrid", 18],
        ["Lisbon", 41],
        ["Pequim", 7],
        ["Rome", 48],
        ["Athens", 27],
        ["Luanda", 76],
        ["Ottawa", 21],
        ["Berlin", 30],
        ["Brasilia", 50],
        ["Beijing", 41]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "City"
    }, {
        "colIndex": 1,
        "colType": "Numeric",
        "colName": "Value"
    }]
};

var relational_03_b = {
        "resultset": [
            ["London", 74],
            ["Paris", 48],
            ["New York", 37],
            ["Prague", 27],
            ["Stockholm", 22],
            ["Sydney", 19],
            ["Madrid", 18],
            ["Lisbon", 41]
        ],
        "metadata": [{
            "colIndex": 0,
            "colType": "String",
            "colName": "City"
        }, {
            "colIndex": 1,
            "colType": "Numeric",
            "colName": "Value"
        }]
    };

var relational_04 = {
    "resultset": [
        ["London", "Ford", 72],
        ["London", "Renault", 50],
        ["London", "BMW", 20],
        ["London", "Mercedes", 23],
        ["London", "Mitsubishi", 72],
        ["London", "Peugeut", 50],
        ["London", "Honda", 20],
        ["London", "Audi", 23],
        //
        ["Paris", "Ford", 27],
        ["Paris", "Renault", 5],
        ["Paris", "BMW", 2],
        ["Paris", "Mercedes", 32],
        ["Paris", "Fiat", 24],
        ["Paris", "Peugeut", 4],
        ["Paris", "Honda", 90],
        ["Paris", "Audi", 53],
        //
        ["Lisbon", "Fiat", 6],
        ["Lisbon", "Peugeut", 4],
        ["Lisbon", "Honda", 1],
        ["Lisbon", "Audi", 3]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "City"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Brand"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "Sales"
    }]
};

var relational_04b = {
    resultset: [
        ["EMEA", "Ford",       72, 127023],
        ["EMEA", "Renault",    50, 107450],
        ["EMEA", "BMW",        20, 231978],
        ["EMEA", "Mercedes",   23, 157450],
        ["EMEA", "Mitsubishi", 72,  97528],
        ["EMEA", "Peugeut",    50, 117922],
        ["EMEA", "Honda",      20, 203318],
        ["EMEA", "Audi",       23, 251240],

        ["APAC", "Ford",       27,  60124],
        ["APAC", "Renault",     5,  50167],
        ["APAC", "BMW",         2,  22000],
        ["APAC", "Mercedes",   32, 107450],
        ["APAC", "Fiat",       24,  82481],
        ["APAC", "Peugeut",     4,   2555],
        ["APAC", "Honda",      90, 636682],
        ["APAC", "Audi",       53, 416727]
    ],
    metadata: [{
        colName: "Region",
        colType: "String"
    }, {
        colName: "Brand",
        colType: "String"
    }, {
        colName: "Quantity",
        colType: "Numeric"
    }, {
        colName: "Sales",
        colType: "Numeric"
    }]
};

var relational_04c = {
    "resultset": [
        ["London", "Ford",       72, 60, 80, 55, 85],
        ["London", "Renault",    50, 45, 55, 42, 59],
        ["London", "BMW",        20, 18, 25, 10, 40],
        ["London", "Mercedes",   23, 20, 30, -8, 37],
        ["London", "Mitsubishi", 72, 60, 90, 50, 97],
        ["London", "Peugeut",    50, 47, 57, 41, 63],
        ["London", "Honda",      20,  2, 50,-10, 75],
        ["London", "Audi",       23, 18, 25, 13, 34],
        //
        ["Paris", "Ford",        27, 25, 36, 10, 41],
        ["Paris", "Renault",      5,  4,  8,  2, 13],
        ["Paris", "BMW",          2, -3, 10,-20, 17],
        ["Paris", "Mercedes",    -32, -40, -20, -56, -15],
        ["Paris", "Fiat",        24, 21, 31, 18, 35],
        ["Paris", "Peugeut",      4, 0,   8, null, null],
        ["Paris", "Honda",       90, null, null, 67, 105],
        ["Paris", "Audi",        53, 30, null, 23, 70],
        //
        ["Lisbon", "Fiat",        6, null, 10, 2, null],
        ["Lisbon", "Peugeut",     4,  2,  9, null, 12],
        ["Lisbon", "Honda",       1,  0,  5, -5,  null],
        ["Lisbon", "Audi",        3, -2, null, -10, null]
    ],
    "metadata": [{
        "colType": "String",
        "colName": "City"
    }, {
        "colType": "String",
        "colName": "Brand"
    }, {
        "colType": "Numeric",
        "colName": "Sales"
    }, {
        "colType": "Numeric",
        "colName": "p25"
    }, {
        "colType": "Numeric",
        "colName": "p75"
    }, {
        "colType": "Numeric",
        "colName": "p5"
    }, {
        "colType": "Numeric",
        "colName": "p95"
    }]
};

var relational_04d = {
    resultset: [
        ["EMEA", "Ford",       72000, 127023],
        ["EMEA", "Renault",    50000, 107450],
        ["EMEA", "BMW",        20000, 231978],
        ["EMEA", "Mercedes",   23000, 157450],
        ["EMEA", "Mitsubishi", 72000,  97528],
        ["EMEA", "Peugeut",    50000, 117922],
        ["EMEA", "Honda",      20000, 203318],
        ["EMEA", "Audi",       23000, 251240],

        ["APAC", "Ford",       27000,  60124],
        ["APAC", "Renault",     5000,  50167],
        ["APAC", "BMW",         2000,  22000],
        ["APAC", "Mercedes",   32000, 107450],
        ["APAC", "Fiat",       24000,  82481],
        //["APAC", "Peugeut",     4000,   2555],
        //["APAC", "Honda",      90000, 636682],
        //["APAC", "Audi",       53000, 416727]
    ],
    metadata: [{
        colName: "Region",
        colType: "String"
    }, {
        colName: "Brand",
        colType: "String"
    }, {
        colName: "OtherGains",
        colType: "Numeric"
    }, {
        colName: "Sales",
        colType: "Numeric"
    }]
};

var relational_05 = {
    "resultset": [
        ["2011-07-03", 72],
        ["2011-07-10", 50],
        ["2011-07-17", 20],
        ["2011-07-24", 23],
        ["2011-07-31", 72],
        ["2011-08-02", 50],

        ["2011-07-03", 60],
        ["2011-07-10", 40],
        ["2011-07-17", 15],
        ["2011-07-24", 3 ],
        ["2011-09-30", 30]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "Date"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "Value"
    }]
};

var relational_06 = {
    "resultset": [
        ["2011-07-03", 72, 80],
        ["2011-07-10", 50, 100],
        ["2011-07-17", 20, 50],
        ["2011-07-24", 23, 33],
        ["2011-07-31", 72, 79],
        ["2011-08-02", 50, 22],
        ["2011-09-30", 30, 30]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "Date"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "salesExpected"
    }, {
        "colIndex": 3,
        "colType": "Numeric",
        "colName": "salesActual"
    }]
};


var relational_07_cross_nulls = {
    "resultset": [
        ["Shipped", "APAC", 1155516.56, 1386619.872],
        ["Shipped", "Japan", 503957.58, 604749.1],
        ["In Process", "APAC", 43971.43, 52765.716],
        ["Disputed", "APAC", 14378.10, 17253.708],
        ["Cancelled", "APAC", 67839.81, 81407.772]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "type"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "territory"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "salesActual"
    }, {
        "colIndex": 3,
        "colType": "Numeric",
        "colName": "salesExpected"
    }]
};

var relational_multi_level_out_of_order = {
    "resultset": [
        // London misses day 06-05
        ["London", "2011-06-12", 50],
        ["London", "2011-07-03", 72],
        // Lisbon contains day 06-05
        ["Lisbon", "2011-06-05", 72],
        ["Lisbon", "2011-06-12", 30],
        ["Lisbon", "2011-07-03", 60]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "City"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Date"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "Quantity"
    }]
};

var relational_null_value = {
    "resultset": [
        ["Lisbon", "2011-06-05", 72],
        ["Lisbon", "2011-06-12", null],
        ["Lisbon", "2011-07-03", 60]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "City"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Date"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "Quantity"
    }]
};


var relational_2nd_series_some_null_categories = {
    "resultset": [
        ["Paris",  "A", 27],
        ["Paris",  "B", 5],
        ["Paris",  "C", 2],
        ["Paris",  "D", 32],

        ["Paris",  "E", 24],
        ["Paris",  "F", 4],
        ["Paris",  "G", 105],
        ["Paris",  "H", 53],

        ["Paris",  "I", 17],

        ["Paris",  "J", 20],

        ["Paris",  "L", 40],
        ["Paris",  "M", 43],
        ["Paris",  "N", 40],

        ["Lisbon", "E", 60],
        ["Lisbon", "F", 40],
        ["Lisbon", "G", 105],
        ["Lisbon", "H", 30],

        ["Lisbon", "J", 50]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "City"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Date"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "Profit"
    }]
};

var relational_one_all_null_series = {
    "resultset": [
        ["Paris",  "A", 27],
        ["Paris",  "B", 5],
        ["Paris",  "C", 2],
        ["Paris",  "D", 32],

        ["Paris",  "E", 24],
        ["Paris",  "F", 4],
        ["Paris",  "G", 105],
        ["Paris",  "H", 53],

        ["Paris",  "I", 17],

        ["Lisbon", "E", null],
        ["Lisbon", "F", null],
        ["Lisbon", "G", null],
        ["Lisbon", "H", null],

        ["Lisbon", "J", null],

        ["London",  "J", 20],

        ["London",  "L", 40],
        ["London",  "M", 43],
        ["London",  "N", 40]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "City"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Date"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "Profit"
    }]
};

var relational_one_all_null_series_others_overlapping = {
    "resultset": [
        ["Paris",  "A", 27],
        ["Paris",  "B", 5],
        ["Paris",  "C", 2],
        ["Paris",  "D", 32],

        ["Paris",  "E", 24],
        ["Paris",  "F", 4],
        ["Paris",  "G", 105],
        ["Paris",  "H", 53],

        ["Paris",  "I", 17],

        ["Lisbon", "E", null],
        ["Lisbon", "F", null],
        ["Lisbon", "G", null],
        ["Lisbon", "H", null],
        ["Lisbon", "J", null],

        ["London",  "J", 20],
        ["London",  "A", 40],
        ["London",  "B", 43],
        ["London",  "N", 40]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "City"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Date"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "Profit"
    }]
};

//pvcTestRealTime
var relational_one_all_null_series_others_overlapping02 = {
    "resultset": [
        ["Paris",  "A", "2011-06-05", 27],
        ["Paris",  "B", "2011-06-05", 5],
        ["Paris",  "C", "2011-06-05", 2],
        ["Paris",  "D", "2011-06-05", 32],

        ["Paris",  "E", "2011-06-05", 24],
        ["Paris",  "F", "2011-06-05", 4],
        ["Paris",  "G", "2011-06-05", 105],
        ["Paris",  "H", "2011-06-05", 53],

        ["Paris",  "I", "2011-06-05", 17],

        ["Lisbon", "E", "2011-06-05", null],
        ["Lisbon", "F", "2011-06-05", null],
        ["Lisbon", "G", "2011-06-05", null],
        ["Lisbon", "H", "2011-06-05", null],
        ["Lisbon", "J", "2011-06-05", null],

        ["London",  "J", "2011-06-05", 20],
        ["London",  "A", "2011-06-05", 40],
        ["London",  "B", "2011-06-05", 43],
        ["London",  "N", "2011-06-05", 40]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "City"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Product"
    }, {
        "colIndex": 2,
        "colType": "String",
        "colName": "Date"
    }, {
        "colIndex": 3,
        "colType": "Numeric",
        "colName": "Profit"
    }]
};



// {"crosstabMode": false, "seriesInRows": false}
var relationalCountrySales = {
    "metadata": [
        {"colIndex": 0, "colName": "Series",  "colLabel": "Series",  "colType": "STRING"},
        {"colIndex": 1, "colName": "Category", "colLabel": "Category", "colType": "STRING"},
        {"colIndex": 2, "colName": "Value",   "colLabel": "Value",   "colType": "NUMERIC"}
    ],

    "resultset": [
        ["2005~Sales", "[Markets].[APAC].[Australia]", 145091.97],
        ["2004~Sales", "[Markets].[APAC].[Australia]", 232396.68],
        ["2003~Sales", "[Markets].[APAC].[Australia]", 253134.45000000007],
        ["2005~Sales", "[Markets].[EMEA].[Austria]", 68250.26000000001],
        ["2004~Sales", "[Markets].[EMEA].[Austria]", 51694.39],
        ["2003~Sales", "[Markets].[EMEA].[Austria]", 82117.88],
        ["2005~Sales", "[Markets].[EMEA].[Belgium]", 25040.11],
        ["2004~Sales", "[Markets].[EMEA].[Belgium]", 80024.05],
        ["2003~Sales", "[Markets].[EMEA].[Belgium]", 3348.46],
        ["2005~Sales", "[Markets].[NA].[Canada]", 33692.97],
        ["2004~Sales", "[Markets].[NA].[Canada]", 135776.09000000003],
        ["2003~Sales", "[Markets].[NA].[Canada]", 54609.49999999999],
        ["2005~Sales", "[Markets].[EMEA].[Denmark]", 26012.870000000003],
        ["2004~Sales", "[Markets].[EMEA].[Denmark]", 120431.55999999998],
        ["2003~Sales", "[Markets].[EMEA].[Denmark]", 99192.72],
        ["2005~Sales", "[Markets].[EMEA].[Finland]", 126851.70999999996],
        ["2004~Sales", "[Markets].[EMEA].[Finland]", 91575.68999999997],
        ["2003~Sales", "[Markets].[EMEA].[Finland]", 111154.51000000002],
        ["2005~Sales", "[Markets].[EMEA].[France]", 242956.4],
        ["2004~Sales", "[Markets].[EMEA].[France]", 555198.6999999998],
        ["2003~Sales", "[Markets].[EMEA].[France]", 312761.42],
        ["2004~Sales", "[Markets].[EMEA].[Germany]", 150418.78],
        ["2003~Sales", "[Markets].[EMEA].[Germany]", 70053.31],
        ["2003~Sales", "[Markets].[Japan].[Hong Kong]", 48784.35999999999],
        ["2004~Sales", "[Markets].[EMEA].[Ireland]", 57756.43],
        ["2005~Sales", "[Markets].[EMEA].[Italy]", 41509.94],
        ["2004~Sales", "[Markets].[EMEA].[Italy]", 199514.58],
        ["2003~Sales", "[Markets].[EMEA].[Italy]", 162601.7],
        ["2005~Sales", "[Markets].[Japan].[Japan]", 38745.34],
        ["2004~Sales", "[Markets].[Japan].[Japan]", 149422.46999999997],
        ["2005~Sales", "[Markets].[APAC].[New Zealand]", 189338.63000000006],
        ["2004~Sales", "[Markets].[APAC].[New Zealand]", 256298.26],
        ["2003~Sales", "[Markets].[APAC].[New Zealand]", 89947.16999999998],
        ["2004~Sales", "[Markets].[EMEA].[Norway]", 110931.1],
        ["2003~Sales", "[Markets].[EMEA].[Norway]", 196532.60000000006],
        ["2004~Sales", "[Markets].[Japan].[Philippines]", 15928.75],
        ["2003~Sales", "[Markets].[Japan].[Philippines]", 78086.98],
        ["2005~Sales", "[Markets].[APAC].[Singapore]", 6763.18],
        ["2004~Sales", "[Markets].[APAC].[Singapore]", 116039.02999999998],
        ["2005~Sales", "[Markets].[Japan].[Singapore]", 6763.18],
        ["2004~Sales", "[Markets].[Japan].[Singapore]", 116039.02999999998],
        ["2003~Sales", "[Markets].[Japan].[Singapore]", 165686.20000000007],
        ["2005~Sales", "[Markets].[EMEA].[Spain]", 326798.16999999987],
        ["2004~Sales", "[Markets].[EMEA].[Spain]", 483545.36000000004],
        ["2003~Sales", "[Markets].[EMEA].[Spain]", 405343.3899999999],
        ["2005~Sales", "[Markets].[EMEA].[Sweden]", 31606.72],
        ["2004~Sales", "[Markets].[EMEA].[Sweden]", 119947.56999999999],
        ["2003~Sales", "[Markets].[EMEA].[Sweden]", 58459.92],
        ["2004~Sales", "[Markets].[EMEA].[Switzerland]", 117713.56000000001],
        ["2005~Sales", "[Markets].[EMEA].[UK]", 40802.810000000005],
        ["2004~Sales", "[Markets].[EMEA].[UK]", 257656.09999999995],
        ["2003~Sales", "[Markets].[EMEA].[UK]", 180421.54999999996]
    ]
};

var relationalCountrySalesCountryLabels = {"[Markets].[APAC].[Australia]": "Australia", "[Markets].[EMEA].[Austria]": "Austria", "[Markets].[EMEA].[Belgium]": "Belgium", "[Markets].[NA].[Canada]": "Canada", "[Markets].[EMEA].[Denmark]": "Denmark", "[Markets].[EMEA].[Finland]": "Finland", "[Markets].[EMEA].[France]": "France", "[Markets].[EMEA].[Germany]": "Germany", "[Markets].[Japan].[Hong Kong]": "Hong Kong", "[Markets].[EMEA].[Ireland]": "Ireland", "[Markets].[EMEA].[Italy]": "Italy", "[Markets].[Japan].[Japan]": "Japan", "[Markets].[APAC].[New Zealand]": "New Zealand", "[Markets].[EMEA].[Norway]": "Norway", "[Markets].[Japan].[Philippines]": "Philippines", "[Markets].[APAC].[Singapore]": "Singapore", "[Markets].[Japan].[Singapore]": "Singapore", "[Markets].[EMEA].[Spain]": "Spain", "[Markets].[EMEA].[Sweden]": "Sweden", "[Markets].[EMEA].[Switzerland]": "Switzerland", "[Markets].[EMEA].[UK]": "UK"};
var relationalCountrySalesYearLabels = {"2005~Sales": "2005", "2004~Sales": "2004", "2003~Sales": "2003"};

var test = {
    "resultset": [
        ["Shipped", 2003, 3573701.2500000014],
        ["Resolved", 2003, 28550.59],
        ["Cancelled", 2003, 75132],
        ["Shipped", 2004, 4750205],
        ["Cancelled", 2004, 187195],
        ["Resolved", 2004, 24078],
        ["On Hold", 2004, 26260],
        ["Shipped", 2005, 1513074],
        ["Resolved", 2005, 98089],
        ["On Hold", 2005, 152718],
        ["Disputed", 2005, 72212.86],
        ["In Process", 2005, 144729]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "STATUS"
    }, {
        "colIndex": 1,
        "colType": "Numeric",
        "colName": "YEAR_ID"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "PRICE"
    }]
};


var testLDots = {
    "resultset": [
        [10, 15],
        [20, 25],
        [30, 35],
        [15, -4],
        [5, -25]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "Numeric",
        "colName": "Position"
    }, {
        "colIndex": 1,
        "colType": "Numeric",
        "colName": "Measurement-1"
    }]
};


var test3 = {
    "resultset": [["2010-05-02", 50000], ["2010-05-09", 70000], ["2010-05-16", null], ["2010-05-23", 0], ["2010-05-30", 0], ["2010-06-06", 0], ["2010-06-13", 0], ["2010-06-20", 0], ["2010-06-27", 0], ["2010-07-04", 0], ["2010-07-11", 0], ["2010-07-18", 161248.9633616415], ["2010-07-25", 138137.33637455967]],
    "metadata": [{
            "colIndex": 0,
            "colType": "String",
            "colName": "[Retailer_Calender].[Continuous_Week]"
        }, {
            "colIndex": 1,
            "colType": "Numeric",
            "colName": "[Measures].[Lost Sales Availability]"
        }
    ]
    };

var testHeatGrid = {
    "resultset": [
        ["Product A", null, 1278, 321, 540, 110],
        ["Product B", 209, 2165, 5000, 1019, null],
        ["Product C", 3694, 5264, 15444, 9205, 312],
        ["Product D", 1257, 1040, 7215, 1512, 18]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "Product-line"
    }, {
        "colIndex": 1,
        "colType": "Numeric",
        "colName": "APAC"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "EMEA"
    }, {
        "colIndex": 3,
        "colType": "Numeric",
        "colName": "Japan"
    }, {
        "colIndex": 4,
        "colType": "Numeric",
        "colName": "NA"
    }, {
        "colIndex": 5,
        "colType": "Numeric",
        "colName": "RoW"
    }]
};

var testHeatGridComp =
    {"metadata": [{"colIndex": 0, "colName": "Territory", "colLabel": "Territory", "colType": "STRING"},
                 {"colIndex": 2, "colName": "Country", "colLabel": "Country", "colType": "STRING"},
                 {"colIndex": 3, "colName": "Products~Land~Classic Cars~Quantity", "colLabel": "Products~Land~Classic Cars~Quantity", "colType": "NUMERIC"},
                 {"colIndex": 4, "colName": "Products~Land~Classic Cars~Sales", "colLabel": "Products~Land~Classic Cars~Sales", "colType": "NUMERIC"},
                 {"colIndex": 5, "colName": "Products~Land~Motorcycles~Quantity", "colLabel": "Products~Land~Motorcycles~Quantity", "colType": "NUMERIC"},
                 {"colIndex": 6, "colName": "Products~Land~Motorcycles~Sales", "colLabel": "Products~Land~Motorcycles~Sales", "colType": "NUMERIC"},
                 {"colIndex": 7, "colName": "Products~Air~Boeing~Quantity", "colLabel": "Products~Planes~Boeing~Quantity", "colType": "NUMERIC"},
                 {"colIndex": 8, "colName": "Products~Air~Boeing~Sales", "colLabel": "Products~Planes~Boeing~Sales", "colType": "NUMERIC"}],
    "resultset": [["APAC", "Australia", null, null, -876, 89968.76, 813, 74853.87000000001],
                  ["APAC", "Hong Kong", 1818, 193085.5400000001, 35, 3845.8, 462, 39649.31],
                  ["APAC", "Japan", 2500, null, 309, 26536.41, 547, 49176.96000000001],
                  ["APAC", "New Zealand", null, 167198.22999999995, 976, 99849.46999999999, 517, 46572.33000000001],
                  ["APAC", "Philippines", 478, 53112.090000000004, 241, 18061.68, 215, 20906.87],
                  ["APAC", "Singapore", 1043, 132890.44, 44, 4175.6, null, null],
                  ["EMEA", "Spain", 937, 101459.47, 197, 26047.66, 200, 17860.44],
                  ["EMEA", "Ireland", 202, 31688.82, 58, 4953.200000000001, 115, 11784.36],
                  ["EMEA", "Italy", 982, 133182.62999999998, 111, 11609.380000000001, 1276, 113717.56],
                  ["EMEA", "Belgium", 147, 20136.960000000003, null, null, 41, 5624.79],
                  ["EMEA", "Denmark", 1244, 157182.48000000004, null, 73000, 70, 7586.45],
                  ["EMEA", "Finland", 1284, 153552.24000000002, 447, 47866.72, 421, 34375.130000000005],
                  ["EMEA", "France", 3540, 388951.2000000002, 2404, 226390.30999999997, 1136, 108155.51000000002],
                  ["EMEA", "Germany", 1281, 148314.99999999997, 121, null, 245, 23001.26],
                  ["EMEA", "Norway", 1158, 134787.36999999997, 484, 51768.63, 325, 29500.7],
                  ["EMEA", "Austria", 4380, 476165.1499999998, 780, 74634.82000000002, 1101, 89985.51],
                  ["EMEA", "Sweden", 552, 69088.06000000001, 133, 15567.25, 104, 8899.6],
                  ["EMEA", "Switzerland", 1078, 117713.55999999998, null, null, null, 10899],
                  ["EMEA", "UK", 1507, 159377.69999999998, 371, 40802.810000000005, 479, 41163.51]]};

/* 4 Measures */
var testHeatGrid4Measures = {
    "metadata": [
        /* Categories */
        {"colIndex": 0, "colName": "Territory", "colLabel": "Territory", "colType": "STRING"},
        {"colIndex": 2, "colName": "Country", "colLabel": "Country", "colType": "STRING"},

        /* Products ~ Land ~ Classic Cars */
        {"colIndex": 3, "colName": "Products~Land~Classic Cars~Quantity", "colLabel": "Products~Land~Classic Cars~Quantity", "colType": "NUMERIC"},
        {"colIndex": 4, "colName": "Products~Land~Classic Cars~Sales", "colLabel": "Products~Land~Classic Cars~Sales", "colType": "NUMERIC"},
        {"colIndex": 5, "colName": "Products~Land~Classic Cars~ExpectedSales", "colLabel": "Products~Land~Classic Cars~Expected Sales", "colType": "NUMERIC"},
        {"colIndex": 6, "colName": "Products~Land~Classic Cars~PreviousSales", "colLabel": "Products~Land~Classic Cars~Previous Sales", "colType": "NUMERIC"},

        /* Products ~ Land ~ Motorcycles */
        {"colIndex": 7, "colName": "Products~Land~Motorcycles~Quantity", "colLabel": "Products~Land~Motorcycles~Quantity", "colType": "NUMERIC"},
        {"colIndex": 8, "colName": "Products~Land~Motorcycles~Sales", "colLabel": "Products~Land~Motorcycles~Sales", "colType": "NUMERIC"},
        {"colIndex": 9, "colName": "Products~Land~Motorcycles~ExpectedSales", "colLabel": "Products~Land~Motorcycles~Expected Sales", "colType": "NUMERIC"},
        {"colIndex": 10, "colName": "Products~Land~Motorcycles~PreviousSales", "colLabel": "Products~Land~Motorcycles~Previous Sales", "colType": "NUMERIC"},

        /* Products ~ Air ~ Boeing */
        {"colIndex": 11, "colName": "Products~Air~Boeing~Quantity", "colLabel": "Products~Planes~Boeing~Quantity", "colType": "NUMERIC"},
        {"colIndex": 12, "colName": "Products~Air~Boeing~Sales", "colLabel": "Products~Planes~Boeing~Sales", "colType": "NUMERIC"},
        {"colIndex": 13, "colName": "Products~Air~Boeing~ExpectedSales", "colLabel": "Products~Land~Motorcycles~Expected Sales", "colType": "NUMERIC"},
        {"colIndex": 14, "colName": "Products~Air~Boeing~PreviousSales", "colLabel": "Products~Land~Motorcycles~Previous Sales", "colType": "NUMERIC"}
    ],

    /*                          Qty   Sales      ESales  PSales  |Qty  Sales      ESales  PSales |Qty  Sales      ESales  PSales */
    "resultset": [
        ["APAC", "Australia",   null,  null,      null,  null,   876,  89968.76,  100000, 60000, 813,  74853.87,  null,   null],
        ["APAC", "Hong Kong",   1818, 193085.54, 200000, 150000, 35,   3845.8,    50000,  0,     462,  39649.31,  20000,  null],
        ["APAC", "Japan",       314,  472710.49, 300000, 123400, 309,  26536.41,  30000,  null,  547,  49176.96,  1000,   500],
        ["APAC", "New Zealand", 1526, 167198.22, null,   100000, 976,  99849.46,  10000,  2000,  517,  46572.33,  300000, 200000],
        ["APAC", "Philippines", 478,  53112.09,  25234,  40000,  241,  18061.68,  4567,   77889, 215,  20906.87,  NaN,    25000],
        ["APAC", "Singapore",   1043, 132890.44, 200000, 500000, 44,   4175.6,    null,   null,  null, 50000.23,  null,   23023],
        ["EMEA", "Spain",       937,  101459.47, 50000,  10000,  197,  26047.66,  20000,  10000, 200,  17860.44,  10000,  12345],
        ["EMEA", "Ireland",     202,  31688.82,  200150, 100000, 58,   4953.20,   1000,   2000,  115,  11784.36,  12000,  10000],
        ["EMEA", "Italy",       982,  133182.62, 150000, 20000,  111,  11609.38,  2000,   null,  1276, 113717.56, 100000, 80000],
        ["EMEA", "Belgium",     147,  20136.96,  20000,  10000,  null,  null,     1000,   7500,  41,   5624.79,   1000,   12345],
        ["EMEA", "Denmark",     1244, 157182.48, 100000, 70000,  null,  null,     null,   50000, 70,   7586.45,   3000,   5000],
        ["EMEA", "Finland",     1284, 153552.24, 200000, 100000, 447,  47866.72,  null,   null,  421,  34375.13,  10000,  10000],
        ["EMEA", "France",      3540, 388951.20, 300000, 200000, 2404, 226390.30, 100500, 70452, 1136, 108155.51, 250000, 100000],
        ["EMEA", "Germany",     1281, 148314.99, 123112, null,   121,  7497.50,   3500,   5000,  245,  23001.26,  20000,  15000],
        ["EMEA", "Norway",      1158, 134787.36, null,   25234,  484,  51768.63,  2000,   50000, 325,  29500.7,   10000,  0],
        ["EMEA", "Austria",     4380, 476165.14, 500000, 25000,  780,  74634.82,  null,   50000, 1101, 89985.51,  10000,  10000],
        ["EMEA", "Sweden",      552,  69088.06,  12845,  null,   133,  15567.25,  10000,  12000, 104,  8899.6,    5000,   23456],
        ["EMEA", "Switzerland", 1078, 117713.55, 250234, 250000, null,  null,     null,   1234,  null,  null,      0,     5000],
        ["EMEA", "UK",          1507, 159377.69, 100000, 243987, 371,  40802.81,  30123,  null,  479,  41163.51,  30000,  25000]
    ]
};

var testNullDisorder = {
    "metadata": [
        {"colIndex":0,"colName":"[Order Status].[Type]","colLabel":"Type","colType":"STRING"},
        {"colIndex":1,"colName":"[Time].[Years]","colLabel":"Years","colType":"STRING"},
        {"colIndex":2,"colName":"[MEASURE:0]","colLabel":"Quantity","colType":"NUMERIC"}
    ],
    "resultset":[
        [{"v":"[Order Status].[Disputed]","f":"Disputed"},{"v":"[Time].[2005]","f":"2005"},{"v":597,"f":"597"}],
        [{"v":"[Order Status].[In Process]","f":"In Process"},{"v":"[Time].[2005]","f":"2005"},{"v":1490,"f":"1,490"}],
        [{"v":"[Order Status].[On Hold]","f":"On Hold"},{"v":"[Time].[2004]","f":"2004"},{"v":217,"f":"217"}],
        [{"v":"[Order Status].[On Hold]","f":"On Hold"},{"v":"[Time].[2005]","f":"2005"},{"v":1662,"f":"1,662"}],
        [{"v":"[Order Status].[Resolved]","f":"Resolved"},{"v":"[Time].[2003]","f":"2003"},{"v":288,"f":"288"}],
        [{"v":"[Order Status].[Resolved]","f":"Resolved"},{"v":"[Time].[2004]","f":"2004"},{"v":253,"f":"253"}],
        [{"v":"[Order Status].[Resolved]","f":"Resolved"},{"v":"[Time].[2005]","f":"2005"},{"v":1119,"f":"1,119"}],
        [{"v":"[Order Status].[Shipped]","f":"Shipped"},{"v":"[Time].[2003]","f":"2003"},{"v":35313,"f":"35,313"}],
        [{"v":"[Order Status].[Shipped]","f":"Shipped"},{"v":"[Time].[2004]","f":"2004"},{"v":47151,"f":"47,151"}],
        [{"v":"[Order Status].[Shipped]","f":"Shipped"},{"v":"[Time].[2005]","f":"2005"},{"v":14607,"f":"14,607"}]
    ]
};

var testLDot = {
    "resultset": [
      [ 10,  10],
      [ 20,  20],
      [ 30,  30],
      [100,  40],
      [ 15,  10],
      [ 30, -30]
//        [ 10,  10],
//        [ 15,  10],
//        [ 20,  20],
//        [ 30,  30],
//        [ 30, -30],
//        [100,  40]
    ],
    "metadata": [{
            "colIndex": 0,
            "colType": "Numeric",
            "colName": "Position"
        }, {
            "colIndex": 1,
            "colType": "Numeric",
            "colName": "Measure-1"
        }
    ]
    };

var testLDot1 = {
    "resultset": [
        [ 15,  10]
    ],
    "metadata": [{
            "colIndex": 0,
            "colType": "Numeric",
            "colName": "Position"
        }, {
            "colIndex": 1,
            "colType": "Numeric",
            "colName": "Measure-1"
        }
    ]
    };

var testLDot2 = {
    "resultset": [
        [10,  10,  15],
        [15,  10,  25],
        [20,  20, -10],
        [30,  30,   5],
        [30, -30,  10],
        [100,  40,  30]
    ],
    "metadata": [{
            "colIndex": 0,
            "colType": "Numeric",
            "colName": "Position"
        }, {
            "colIndex": 1,
            "colType": "Numeric",
            "colName": "Measure-1"
        }, {
            "colIndex": 2,
            "colType": "Numeric",
            "colName": "Measure-2"
        }
    ]
    };

var testArea2 = {
    "resultset": [
        [0, 0, 0],
        [10, 10, 15],
        [20, 20, 10],
        [30, 30, +5],
        [40, 0, 10],
        [15, 10, 25],
        [100, 40, 30],
        [110, 0, 0]
    ],
    "metadata": [{
            "colIndex": 0,
            "colType": "Numeric",
            "colName": "Position"
        }, {
            "colIndex": 1,
            "colType": "Numeric",
            "colName": "Measure-1"
        }, {
            "colIndex": 2,
            "colType": "Numeric",
            "colName": "Measure-2"
        }
    ]
    };

var testWaterfall_01 = {
    "resultset": [
        ["Total",  "U", 800, 1200],
        ["USA",    "D", 100,  600],
        ["Europe", "D", 400,  300],
        ["Asia",   "D", 200,  100],
        ["RoW",    "D", 100,  200]
    ],
    "metadata": [{
            "colIndex": 0,
            "colType": "String",
            "colName": "Category"
        }, {
            "colIndex": 1,
            "colType": "String",
            "colName": "Cumulated"
        }, {
            "colIndex": 2,
            "colType": "Numeric",
            "colName": "Product A"
        }, {
            "colIndex": 3,
            "colType": "Numeric",
            "colName": "Product B"
        }
    ]
    };

var testWaterfall_02 = {
    "resultset": [
        ["Total",  "U", 800, 1200],
        ["USA",    "D", 100,  600],
        ["Europe", "D", 400,  300],
        ["RoW",    "0", 300,  300],
        ["Japan",   "D", 100,  75],
        ["China",   "D", 100,  25],
        ["S. America", "D", 50,  80],
        ["MEA",    "D", 25,  80],
        ["Mexico",    "D", 25,  40]
    ],
    "metadata": [{
            "colIndex": 0,
            "colType": "String",
            "colName": "Category"
        }, {
            "colIndex": 1,
            "colType": "String",
            "colName": "Cumulated"
        }, {
            "colIndex": 2,
            "colType": "Numeric",
            "colName": "Product A"
        }, {
            "colIndex": 3,
            "colType": "Numeric",
            "colName": "Product B"
        }
    ]
    };

var testWaterfallBalance = {
    "resultset": [
        ["Income", "Sales",       100,  600],
        ["Income", "Financial",   400,  300],
        ["Income", "Tax Return",  300,   300],
        ["Cost",   null,    -100, -200]
    ],
    "metadata": [{
            "colIndex": 0,
            "colType": "String",
            "colName": "Account Type"
        }, {
            "colIndex": 1,
            "colType": "String",
            "colName": "Account Source"
        }, {
            "colIndex": 2,
            "colType": "Numeric",
            "colName": "Product A"
        }, {
            "colIndex": 3,
            "colType": "Numeric",
            "colName": "Product B"
        }
    ]
};

var testWaterfallStocks = {
        "resultset": [
            ["Previous", 1000,  null],
            ["Jan",      100, 600],
            ["Feb",      400, 300],
            ["March",    300, 300],
            ["April",    100, 200]
        ],
        "metadata": [{
                "colIndex": 0,
                "colType": "String",
                "colName": "Date"
            }, {
                "colIndex": 1,
                "colType": "Numeric",
                "colName": "Opened"
            }, {
                "colIndex": 2,
                "colType": "Numeric",
                "colName": "Closed"
            }
        ]
    };

var testWaterfallInventory = {
    "resultset": [
        // Period       Initial, Purch, Tr.In,  Sold,  Tr.Out

        [{v: '_', f: "Prior Year"},
                        8000,    null,  null,   null,  null],
        ["Jan",         null,    1000,  2000,   3000,   500],
        ["Feb",         null,    1500,  1000,   4000,  1000],
        ["March",       null,     920,   150,   1000,    20],
        ["April",       null,     500,  1500,   1400,   200],
        ["May",         null,    1300,   800,   1900,    50],
        ["June",        null,    1000,   100,   2000,   500]
    ],
    "metadata": [{
            "colIndex": 0,
            "colType":  "String",
            "colName":  "period",
            "colLabel": "Period"
        }, {
            "colIndex": 1,
            "colType":  "Numeric",
            "colName":  "initial",
            "colLabel": "Prior Year"
        }, {
            "colIndex": 2,
            "colType":  "Numeric",
            "colName":  "purchased",
            "colLabel": "Purchased"
        }, {
            "colIndex": 3,
            "colType":  "Numeric",
            "colName":  "transfIn",
            "colLabel": "Transferred In"
        }, {
            "colIndex": 4,
            "colType":  "Numeric",
            "colName":  "sold",
            "colLabel": "Sold"
        }, {
            "colIndex": 5,
            "colType":  "Numeric",
            "colName":  "transfOut",
            "colLabel": "Transferred Out"
        }
    ]
};

var testWaterfall1 = {
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "Territory"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Region"
    }, {
        "colIndex": 2,
        "colType": "String",
        "colName": "Market"
    }, {
        "colIndex": 3,
        "colType": "Numeric",
        "colName": "Product A"
    }, {
        "colIndex": 4,
        "colType": "Numeric",
        "colName": "Product B"
    }],
    "resultset": [
        ["USA",    'Kansas',     null,         100,  600],

        ["USA",    'New York',   'Fair',       500,  600],
        ["USA",    'New York',   'Restaurant', 200,  100],
        ["USA",    'New York',   'House',      100,  200],

        ["USA",    'Idaho',      'Farm',       200,  100],
        ["USA",    'Idaho',      'Fairy',      500,  600],
        ["USA",    'Idaho',      'House',      400,  100],
        ["USA",    'Idaho',      'Grocery',    200,  300],

        ["Europe", null,         null,         400,  300],

        ["RoW",    "Japan",      null,         100,   75],
        ["RoW",    "China",      null,         100,   25],
        ["RoW",    "S. America", null,          50,   80],
        ["RoW",    "India",      null,          25,   80],
        ["RoW",    "Mexico",     null,          25,   40]
    ]
};

var testTreemapThreeLevel = testSunburstThreeLevel = {
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "Territory"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Region"
    }, {
        "colIndex": 2,
        "colType": "String",
        "colName": "Market"
    }, {
        "colIndex": 3,
        "colType": "Numeric",
        "colName": "Sales"
    }],
    "resultset": [
        ["USA",    'Kansas',     null,         100],

        ["USA",    'New York',   'Fair',       500],
        ["USA",    'New York',   'Restaurant', 200],
        ["USA",    'New York',   'House',      100],

        ["USA",    'Idaho',      'Farm',       200],
        ["USA",    'Idaho',      'Fairy',      500],
        ["USA",    'Idaho',      'House',      400],
        ["USA",    'Idaho',      'Grocery',    200],

        ["Europe", null,         null,         400],

        ["Moon",   "Big Valey",  "North Hole", 300],
        ["Moon",   "Big Valey",  "South Hole", 100],

        ["RoW",    "Japan",      null,         100],
        ["RoW",    "China",      null,         100],
        ["RoW",    "S. America", null,          50],
        ["RoW",    "India",      null,          25],
        ["RoW",    "Mexico",     null,          25]
    ]
};

//pvcTestRealTime
var testTreemapThreeLevel02 = {
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "Territory"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Region"
    }, {
        "colIndex": 2,
        "colType": "String",
        "colName": "Market"
    }, {
        "colIndex": 3,
        "colType": "String",
        "colName": "Date"
    }, {
        "colIndex": 4,
        "colType": "Numeric",
        "colName": "Sales"
    }],
    "resultset": [
        ["USA",    'Kansas',     null         , "2011-06-05",       100],

        ["USA",    'New York',   'Fair'       , "2011-06-05",       500],
        ["USA",    'New York',   'Restaurant' , "2011-06-05",       200],
        ["USA",    'New York',   'House'      , "2011-06-05",       100],

        ["USA",    'Idaho',      'Farm'       , "2011-06-05",       200],
        ["USA",    'Idaho',      'Fairy'      , "2011-06-05",       500],
        ["USA",    'Idaho',      'House'      , "2011-06-05",       400],
        ["USA",    'Idaho',      'Grocery'    , "2011-06-05",       200],

        ["Europe", null,         null         , "2011-06-05",       400],

        ["Moon",   "Big Valey",  "North Hole" , "2011-06-05",       300],
        ["Moon",   "Big Valey",  "South Hole" , "2011-06-05",       100],

        ["RoW",    "Japan",      null         , "2011-06-05",       100],
        ["RoW",    "China",      null         , "2011-06-05",       100],
        ["RoW",    "S. America", null         , "2011-06-05",        50],
        ["RoW",    "India",      null         , "2011-06-05",        25],
        ["RoW",    "Mexico",     null         , "2011-06-05",        25]
    ]
};

var testTreemapAllNull = {
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "Territory"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Region"
    }, {
        "colIndex": 2,
        "colType": "String",
        "colName": "Market"
    }, {
        "colIndex": 3,
        "colType": "Numeric",
        "colName": "Sales"
    }],
    "resultset": [
        ["USA",    'Kansas',     null,         null],
        ["USA",    'New York',   'Fair',       null],
        ["USA",    'New York',   'Restaurant', null],
        ["USA",    'New York',   'House',      null],
        ["USA",    'Idaho',      'Farm',       null],
        ["USA",    'Idaho',      'Fairy',      null],
        ["USA",    'Idaho',      'House',      null],
        ["USA",    'Idaho',      'Grocery',    null],
        ["Europe", null,         null,         null],
        ["Moon",   "Big Valey",  "North Hole", null],
        ["Moon",   "Big Valey",  "South Hole", null],
        ["RoW",    "Japan",      null,         null],
        ["RoW",    "China",      null,         null],
        ["RoW",    "S. America", null,         null],
        ["RoW",    "India",      null,         null],
        ["RoW",    "Mexico",     null,         null]
    ]
};

var testTreemapSingleLevel = testSunburstSingleLevel = {
   metadata: [{
        "colIndex": 0,
        "colType": "String",
        "colName": "Territory"
    }, {
        "colIndex": 1,
        "colType": "Numeric",
        "colName": "Sales"
    }],
  resultset:
      [[{v: "[Markets].[APAC]",  f: "APAC" }, {v: 1281705.89, f: "11,878.00"}],
       [{v: "[Markets].[EMEA]",  f: "EMEA" }, {v: 5008224.32, f: "48,578.00"}],
       [{v: "[Markets].[Japan]", f: "Japan"}, {v: 503957.58,  f: "3,923.00" }],
       [{v: "[Markets].[NA]",    f: "NA"   }, {v: 3852061.39, f: "36,952.00"}]]
};

var testTreemapZeroSizeBranches = {
    "resultset" : [
        ["CA","Alameda","HQ",{"f":"","v":0},{"f":"","v":0},{"f":"204","v":204},{"f":"","v":0},{"f":"","v":0},{"f":"","v":0}],
        ["CA","Beverly Hills","Store 6",{"f":"","v":0},{"f":"576","v":576},{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"","v":0}],
        ["CA","Los Angeles","Store 7",{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"744","v":744}],
        ["CA","San Diego","Store 24",{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"744","v":744}],
        ["CA","San Francisco","Store 14",{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"48","v":48},{"f":"","v":0}],
        ["OR","Portland","Store 11",{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"744","v":744}],
        ["OR","Salem","Store 13",{"f":"888","v":888},{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"","v":0}],
        ["WA","Bellingham","Store 2",{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"48","v":48},{"f":"","v":0}],
        ["WA","Bremerton","Store 3",{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"744","v":744}],
        ["WA","Seattle","Store 15",{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"744","v":744}],
        ["WA","Spokane","Store 16",{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"744","v":744}],
        ["WA","Tacoma","Store 17",{"f":"888","v":888},{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"","v":0}],
        ["WA","Walla Walla","Store 22",{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"48","v":48},{"f":"","v":0}],
        ["WA","Yakima","Store 23",{"f":"","v":0},{"f":"","v":0},{"f":"","v":0},{"f":"228","v":228},{"f":"","v":0},{"f":"","v":0}]
    ],
    "metadata": [
        {"colIndex":0,"colType":"String","colName":"Store State"},
        {"colIndex":1,"colType":"String","colName":"Store City"},
        {"colIndex":2,"colType":"String","colName":"Store Name"},
        {"colIndex":3,"colType":"Numeric","colName":"Deluxe Supermarket ~ Count"},
        {"colIndex":4,"colType":"Numeric","colName":"Gourmet Supermarket ~ Count"},
        {"colIndex":5,"colType":"Numeric","colName":"HeadQuarters ~ Count"},
        {"colIndex":6,"colType":"Numeric","colName":"Mid-Size Grocery ~ Count"},
        {"colIndex":7,"colType":"Numeric","colName":"Small Grocery ~ Count"},
        {"colIndex":8,"colType":"Numeric","colName":"Supermarket ~ Count"}
    ]
};

var testTreemapThreeLevelsSingleDatumNonZero = {
    "resultset" : [
        ["CA","Alameda","HQ", {"f":"100","v":100}],
    ],
    "metadata": [
        {"colIndex":0,"colType":"String","colName":"Store State"},
        {"colIndex":1,"colType":"String","colName":"Store City"},
        {"colIndex":2,"colType":"String","colName":"Store Name"},
        {"colIndex":3,"colType":"Numeric","colName":"Deluxe Supermarket ~ Count"}
    ]
};

var testTreemapSingleLevelSingleDatumNonZero = {
    "resultset" : [
        ["CA", {"f":"100","v":100}],
    ],
    "metadata": [
        {"colIndex":0,"colType":"String","colName":"Store State"},
        {"colIndex":3,"colType":"Numeric","colName":"Count"}
    ]
};

var testTreemapSingleLevelSingleDatumZero = {
    "resultset" : [
        ["CA", {"f":"100","v":0}],
    ],
    "metadata": [
        {"colIndex":0,"colType":"String","colName":"Store State"},
        {"colIndex":3,"colType":"Numeric","colName":"Count"}
    ]
};

var testWaterfall1Neg = {
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "Territory"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Region"
    }, {
        "colIndex": 2,
        "colType": "String",
        "colName": "Market"
    }, {
        "colIndex": 3,
        "colType": "Numeric",
        "colName": "Product A"
    }, {
        "colIndex": 4,
        "colType": "Numeric",
        "colName": "Product B"
    }, {
        "colIndex": 5,
        "colType": "Numeric",
        "colName": "Product C"
    }],
    "resultset": [
        //  USA                                  600    200   100      // delta=900, -0   (+900) acc=1900
        ["USA",    'Kansas',     null,        -100,   600,  300],    // delta=900, -100 (+800) acc=1000

        //  USA       New York                   700   -400  -200      // delta=700, -600 (+100) acc=200
        ["USA",    'New York',   'Fair',       500,  -600, -100],    // delta=500, -700 (-200) acc=100
        //["USA",    'New York',   'Restaurant', 200,   100, -234],
        ["USA",    'New York',   'House',      200,    200, -100]//,  // delta=400, -100 (+300) acc=300
        //  ["USA",    'Idaho',      'Farm',       -200, -100,   50],
        //  ["USA",    'Idaho',      'Fair',       -500, -600,  -14],
        //  ["USA",    'Idaho',      'House',      400,   100,  230],
        //  ["USA",    'Idaho',      'Grocery',    200,   300,  150],
        //  ["Europe", null,         null,         400,  -300,  360],
        //  ["RoW",    "Japan",      null,         100,    75,    0],
        //  ["RoW",    "China",      null,         100,    25, null],
        //  ["RoW",    "S. America", null,          50,    80,  -35],
        //  ["RoW",    "MEA",        null,          25,    80,  -90],
        //  ["RoW",    "Mexico",     null,          25,    40,  -20]
    ]
};

var bullet_valueOnly = {
    "resultset": [
        [80], [60]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "Numeric",
        "colName": "Value"
    }]
};


var bullet_NameValue = {
    "resultset": [
        ["Europe", 800],
        ["Asia", 100],
        ["Africa", 400]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "Description"
    }, {
        "colIndex": 1,
        "colType": "Numeric",
        "colName": "Value"
    }]
};

var bullet_NameValueMarker = {
    "resultset": [
        ["Europe", 800, 300],
        ["Asia", 100,  500],
        ["Africa", 400,  100]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "Description"
    }, {
        "colIndex": 1,
        "colType": "Numeric",
        "colName": "Value"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "Marker"
    }]
};


var bullet_NameDescValueMarkerRanges = {
    "resultset": [
        ["Europe", "Profit", 80, 120, 50, 150, 200],
        ["Asia", "Count", 100,  600, 300, 600, 900],
        ["Africa", "Result", 400,  500, 100, 200, 300]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "Title"
    }, {
        "colIndex": 1,
        "colType": "String",
        "colName": "Subtitle"
    }, {
        "colIndex": 2,
        "colType": "Numeric",
        "colName": "Value"
    }, {
        "colIndex": 3,
        "colType": "Numeric",
        "colName": "Marker"
    }, {
        "colIndex": 4,
        "colType": "Numeric",
        "colName": "Range1"
    }, {
        "colIndex": 5,
        "colType": "Numeric",
        "colName": "Range2"
    }, {
        "colIndex": 6,
        "colType": "Numeric",
        "colName": "Range3"
    }]
};

var parCoordTest_01 = {
    "resultset": [
        ["pat 1",  40, "M", 130, 6],
        ["pat 2",  50, "F", 140, 5],
        ["pat 3",  50, "M", 135, 4]
    ],
    "metadata": [{
        "colIndex": 0,
        "colType": "String",
        "colName": "Category"
    }, {
        "colIndex": 1,
        "colType": "Numeric",
        "colName": "Age"
    }, {
        "colIndex": 2,
        "colType": "String",
        "colName": "Gender"
    }, {
        "colIndex": 3,
        "colType": "Numeric",
        "colName": "Blood Pressure mmHg"
    }, {
        "colIndex": 4,
        "colType": "Numeric",
        "colName": "Cholesterol mmol"
    }]
};

var testMeasureDiscrim = {
    "metadata":[
        {colName: "City",       colType: "STRING" },
        {colName: "Period",     colType: "STRING" },
        {colName: "Count",      colType: "NUMERIC"},
        {colName: "AvgLatency", colType: "NUMERIC"}
    ],
    resultset: [
        ['London', 'Jan', 35000,  141.3],
        ['London', 'Apr', 40000,  120.12],
        ['London', 'Jul', 45000,  115.6],
        ['London', 'Oct', null,   110.37],
        ['Paris',  'Jan', 70000,  null],
        ['Paris',  'Apr', 80000,  180.9],
        ['Paris',  'Jul', 115000, 170.7],
        ['Paris',  'Oct', 45000,  145.5],
        ['Lisbon', 'Jan', 70000,  200.7],
        ['Lisbon', 'Apr', 90000,  190.3],
        ['Lisbon', 'Jul', 120000, 180.2],
        ['Lisbon', 'Oct', 30000,  130.067]
    ]
};

var steelWheels02 = {
    "metadata":[
        {"colIndex":0, "colName":"[Customers].[Customer]", "colLabel":"Customer",  "colType":"STRING" },
        {"colIndex":1, "colName":"[Markets].[Territory]",  "colLabel":"Territory", "colType":"STRING" },
        {"colIndex":2, "colName":"[Product].[Line]",       "colLabel":"Line",      "colType":"STRING" },
        {"colIndex":3, "colName":"[MEASURE:0]",            "colLabel":"Quantity",  "colType":"NUMERIC"},
        {"colIndex":4, "colName":"[MEASURE:1]",            "colLabel":"Sales",     "colType":"NUMERIC"}
     ],

     "resultset":[
        [{v:"[Customers].[AV Stores, Co.]", f:"AV Stores, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:628,f:"628"},{v:61072.54000000001,f:"61.073"}],
        [{v:"[Customers].[AV Stores, Co.]", f:"AV Stores, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Ships]", f:"Ships"},{v:257,f:"257"},{v:21111.84,f:"21.112"}],
        [{v:"[Customers].[AV Stores, Co.]", f:"AV Stores, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Trains]", f:"Trains"},{v:120,f:"120"},{v:8037.139999999999,f:"8.037"}],
        [{v:"[Customers].[AV Stores, Co.]", f:"AV Stores, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:773,f:"773"},{v:67586.29,f:"67.586"}],
        [{v:"[Customers].[Alpha Cognac]", f:"Alpha Cognac"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:126,f:"126"},{v:20743.56,f:"20.744"}],
        [{v:"[Customers].[Alpha Cognac]", f:"Alpha Cognac"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Planes]", f:"Planes"},{v:218,f:"218"},{v:19072.64,f:"19.073"}],
        [{v:"[Customers].[Alpha Cognac]", f:"Alpha Cognac"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Ships]", f:"Ships"},{v:247,f:"247"},{v:21782.88,f:"21.783"}],
        [{v:"[Customers].[Alpha Cognac]", f:"Alpha Cognac"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:96,f:"96"},{v:8889.36,f:"8.889"}],
        [{v:"[Customers].[Amica Models & Co.]", f:"Amica Models & Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:149,f:"149"},{v:28921.619999999995,f:"28.922"}],
        [{v:"[Customers].[Amica Models & Co.]", f:"Amica Models & Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Ships]", f:"Ships"},{v:82,f:"82"},{v:6948.62,f:"6.949"}],
        [{v:"[Customers].[Amica Models & Co.]", f:"Amica Models & Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Trains]", f:"Trains"},{v:22,f:"22"},{v:2418.24,f:"2.418"}],
        [{v:"[Customers].[Amica Models & Co.]", f:"Amica Models & Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Trucks and Buses]", f:"Trucks and Buses"},{v:24,f:"24"},{v:2800.08,f:"2.800"}],
        [{v:"[Customers].[Amica Models & Co.]", f:"Amica Models & Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:566,f:"566"},{v:53028.700000000004,f:"53.029"}],
        [{v:"[Customers].[Anna's Decorations, Ltd]", f:"Anna's Decorations, Ltd"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:744,f:"744"},{v:74492.24,f:"74.492"}],
        [{v:"[Customers].[Anna's Decorations, Ltd]", f:"Anna's Decorations, Ltd"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Motorcycles]", f:"Motorcycles"},{v:219,f:"219"},{v:18877.11,f:"18.877"}],
        [{v:"[Customers].[Anna's Decorations, Ltd]", f:"Anna's Decorations, Ltd"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Trucks and Buses]", f:"Trucks and Buses"},{v:286,f:"286"},{v:29916.87,f:"29.917"}],
        [{v:"[Customers].[Anna's Decorations, Ltd]", f:"Anna's Decorations, Ltd"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:220,f:"220"},{v:30709.909999999996,f:"30.710"}],
        [{v:"[Customers].[Atelier graphique]", f:"Atelier graphique"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:156,f:"156"},{v:16560.3,f:"16.560"}],
        [{v:"[Customers].[Atelier graphique]", f:"Atelier graphique"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Motorcycles]", f:"Motorcycles"},{v:71,f:"71"},{v:5307.9800000000005,f:"5.308"}],
        [{v:"[Customers].[Atelier graphique]", f:"Atelier graphique"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:43,f:"43"},{v:2311.68,f:"2.312"}],
        [{v:"[Customers].[Australian Collectables, Ltd]", f:"Australian Collectables, Ltd"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:119,f:"119"},{v:14241.32,f:"14.241"}],
        [{v:"[Customers].[Australian Collectables, Ltd]", f:"Australian Collectables, Ltd"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Planes]", f:"Planes"},{v:63,f:"63"},{v:3843.84,f:"3.844"}],
        [{v:"[Customers].[Australian Collectables, Ltd]", f:"Australian Collectables, Ltd"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Ships]", f:"Ships"},{v:32,f:"32"},{v:3070.4,f:"3.070"}],
        [{v:"[Customers].[Australian Collectables, Ltd]", f:"Australian Collectables, Ltd"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:491,f:"491"},{v:43435.9,f:"43.436"}],
        [{v:"[Customers].[Australian Collectors, Co.]", f:"Australian Collectors, Co."},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:451,f:"451"},{v:50697.09,f:"50.697"}],
        [{v:"[Customers].[Australian Collectors, Co.]", f:"Australian Collectors, Co."},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Motorcycles]", f:"Motorcycles"},{v:490,f:"490"},{v:53818.659999999996,f:"53.819"}],
        [{v:"[Customers].[Australian Collectors, Co.]", f:"Australian Collectors, Co."},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Planes]", f:"Planes"},{v:419,f:"419"},{v:39878.759999999995,f:"39.879"}],
        [{v:"[Customers].[Australian Collectors, Co.]", f:"Australian Collectors, Co."},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Trucks and Buses]", f:"Trucks and Buses"},{v:166,f:"166"},{v:18388.78,f:"18.389"}],
        [{v:"[Customers].[Australian Collectors, Co.]", f:"Australian Collectors, Co."},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:400,f:"400"},{v:38212.119999999995,f:"38.212"}],
        [{v:"[Customers].[Australian Gift Network, Co]", f:"Australian Gift Network, Co"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:117,f:"117"},{v:16973.760000000002,f:"16.974"}],
        [{v:"[Customers].[Australian Gift Network, Co]", f:"Australian Gift Network, Co"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Motorcycles]", f:"Motorcycles"},{v:121,f:"121"},{v:14492.09,f:"14.492"}],
        [{v:"[Customers].[Australian Gift Network, Co]", f:"Australian Gift Network, Co"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Planes]", f:"Planes"},{v:88,f:"88"},{v:7237.9400000000005,f:"7.238"}],
        [{v:"[Customers].[Australian Gift Network, Co]", f:"Australian Gift Network, Co"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Trains]", f:"Trains"},{v:33,f:"33"},{v:1681.35,f:"1.681"}],
        [{v:"[Customers].[Australian Gift Network, Co]", f:"Australian Gift Network, Co"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Trucks and Buses]", f:"Trucks and Buses"},{v:91,f:"91"},{v:11297.54,f:"11.298"}],
        [{v:"[Customers].[Australian Gift Network, Co]", f:"Australian Gift Network, Co"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:95,f:"95"},{v:7786.4400000000005,f:"7.786"}],
        [{v:"[Customers].[Auto Assoc. & Cie.]", f:"Auto Assoc. & Cie."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:87,f:"87"},{v:14380.7,f:"14.381"}],
        [{v:"[Customers].[Auto Assoc. & Cie.]", f:"Auto Assoc. & Cie."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Trucks and Buses]", f:"Trucks and Buses"},{v:164,f:"164"},{v:19292.859999999997,f:"19.293"}],
        [{v:"[Customers].[Auto Assoc. & Cie.]", f:"Auto Assoc. & Cie."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:386,f:"386"},{v:31160.76,f:"31.161"}],
        [{v:"[Customers].[Auto Canal+ Petit]", f:"Auto Canal+ Petit"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:368,f:"368"},{v:41773.090000000004,f:"41.773"}],
        [{v:"[Customers].[Auto Canal+ Petit]", f:"Auto Canal+ Petit"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Motorcycles]", f:"Motorcycles"},{v:633,f:"633"},{v:51397.57,f:"51.398"}],
        [{v:"[Customers].[Auto-Moto Classics Inc.]", f:"Auto-Moto Classics Inc."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Planes]", f:"Planes"},{v:120,f:"120"},{v:9175.86,f:"9.176"}],
        [{v:"[Customers].[Auto-Moto Classics Inc.]", f:"Auto-Moto Classics Inc."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Ships]", f:"Ships"},{v:63,f:"63"},{v:6206.27,f:"6.206"}],
        [{v:"[Customers].[Auto-Moto Classics Inc.]", f:"Auto-Moto Classics Inc."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:104,f:"104"},{v:11097.13,f:"11.097"}],
        [{v:"[Customers].[Baane Mini Imports]", f:"Baane Mini Imports"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:267,f:"267"},{v:28912.769999999997,f:"28.913"}],
        [{v:"[Customers].[Baane Mini Imports]", f:"Baane Mini Imports"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Motorcycles]", f:"Motorcycles"},{v:212,f:"212"},{v:21244.339999999997,f:"21.244"}],
        [{v:"[Customers].[Baane Mini Imports]", f:"Baane Mini Imports"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Trains]", f:"Trains"},{v:72,f:"72"},{v:11310.36,f:"11.310"}],
        [{v:"[Customers].[Baane Mini Imports]", f:"Baane Mini Imports"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Trucks and Buses]", f:"Trucks and Buses"},{v:308,f:"308"},{v:37075.64,f:"37.076"}],
        [{v:"[Customers].[Baane Mini Imports]", f:"Baane Mini Imports"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:223,f:"223"},{v:18056.079999999998,f:"18.056"}],
        [{v:"[Customers].[Bavarian Collectables Imports, Co.]", f:"Bavarian Collectables Imports, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Planes]", f:"Planes"},{v:245,f:"245"},{v:23001.26,f:"23.001"}],
        [{v:"[Customers].[Bavarian Collectables Imports, Co.]", f:"Bavarian Collectables Imports, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Ships]", f:"Ships"},{v:55,f:"55"},{v:5501,f:"5.501"}],
        [{v:"[Customers].[Bavarian Collectables Imports, Co.]", f:"Bavarian Collectables Imports, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:101,f:"101"},{v:6491.66,f:"6.492"}],
        [{v:"[Customers].[Blauer See Auto, Co.]", f:"Blauer See Auto, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:466,f:"466"},{v:55505.91999999999,f:"55.506"}],
        [{v:"[Customers].[Blauer See Auto, Co.]", f:"Blauer See Auto, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Trains]", f:"Trains"},{v:89,f:"89"},{v:5043.42,f:"5.043"}],
        [{v:"[Customers].[Blauer See Auto, Co.]", f:"Blauer See Auto, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Trucks and Buses]", f:"Trucks and Buses"},{v:81,f:"81"},{v:10178,f:"10.178"}],
        [{v:"[Customers].[Blauer See Auto, Co.]", f:"Blauer See Auto, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:175,f:"175"},{v:14444.25,f:"14.444"}],
        [{v:"[Customers].[Boards & Toys Co.]", f:"Boards & Toys Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:35,f:"35"},{v:3987.2,f:"3.987"}],
        [{v:"[Customers].[Boards & Toys Co.]", f:"Boards & Toys Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Ships]", f:"Ships"},{v:36,f:"36"},{v:2315.88,f:"2.316"}],
        [{v:"[Customers].[Boards & Toys Co.]", f:"Boards & Toys Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:31,f:"31"},{v:2826.27,f:"2.826"}],
        [{v:"[Customers].[CAF Imports]", f:"CAF Imports"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:91,f:"91"},{v:15330.7,f:"15.331"}],
        [{v:"[Customers].[CAF Imports]", f:"CAF Imports"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Ships]", f:"Ships"},{v:245,f:"245"},{v:21688.100000000002,f:"21.688"}],
        [{v:"[Customers].[CAF Imports]", f:"CAF Imports"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Trains]", f:"Trains"},{v:29,f:"29"},{v:3070.52,f:"3.071"}],
        [{v:"[Customers].[CAF Imports]", f:"CAF Imports"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:103,f:"103"},{v:9552.73,f:"9.553"}],
        [{v:"[Customers].[Cambridge Collectables Co.]", f:"Cambridge Collectables Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:29,f:"29"},{v:6463.23,f:"6.463"}],
        [{v:"[Customers].[Cambridge Collectables Co.]", f:"Cambridge Collectables Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Planes]", f:"Planes"},{v:52,f:"52"},{v:3199.92,f:"3.200"}],
        [{v:"[Customers].[Cambridge Collectables Co.]", f:"Cambridge Collectables Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Ships]", f:"Ships"},{v:40,f:"40"},{v:3838,f:"3.838"}],
        [{v:"[Customers].[Cambridge Collectables Co.]", f:"Cambridge Collectables Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Trucks and Buses]", f:"Trucks and Buses"},{v:32,f:"32"},{v:3360,f:"3.360"}],
        [{v:"[Customers].[Cambridge Collectables Co.]", f:"Cambridge Collectables Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:204,f:"204"},{v:19302.47,f:"19.302"}],
        [{v:"[Customers].[Canadian Gift Exchange Network]", f:"Canadian Gift Exchange Network"},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:175,f:"175"},{v:27160.93,f:"27.161"}],
        [{v:"[Customers].[Canadian Gift Exchange Network]", f:"Canadian Gift Exchange Network"},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Trucks and Buses]", f:"Trucks and Buses"},{v:351,f:"351"},{v:32493.22,f:"32.493"}],
        [{v:"[Customers].[Canadian Gift Exchange Network]", f:"Canadian Gift Exchange Network"},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:177,f:"177"},{v:15584.77,f:"15.585"}],
        [{v:"[Customers].[Classic Gift Ideas, Inc]", f:"Classic Gift Ideas, Inc"},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:96,f:"96"},{v:13499.5,f:"13.500"}],
        [{v:"[Customers].[Classic Gift Ideas, Inc]", f:"Classic Gift Ideas, Inc"},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Planes]", f:"Planes"},{v:98,f:"98"},{v:11087.390000000001,f:"11.087"}],
        [{v:"[Customers].[Classic Gift Ideas, Inc]", f:"Classic Gift Ideas, Inc"},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Ships]", f:"Ships"},{v:65,f:"65"},{v:5910.48,f:"5.910"}],
        [{v:"[Customers].[Classic Gift Ideas, Inc]", f:"Classic Gift Ideas, Inc"},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Trucks and Buses]", f:"Trucks and Buses"},{v:132,f:"132"},{v:13805.98,f:"13.806"}],
        [{v:"[Customers].[Classic Gift Ideas, Inc]", f:"Classic Gift Ideas, Inc"},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:277,f:"277"},{v:23203.620000000003,f:"23.204"}],
        [{v:"[Customers].[Classic Legends Inc.]", f:"Classic Legends Inc."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:219,f:"219"},{v:27950.57,f:"27.951"}],
        [{v:"[Customers].[Classic Legends Inc.]", f:"Classic Legends Inc."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Ships]", f:"Ships"},{v:174,f:"174"},{v:14057.47,f:"14.057"}],
        [{v:"[Customers].[Classic Legends Inc.]", f:"Classic Legends Inc."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Trains]", f:"Trains"},{v:21,f:"21"},{v:2296.77,f:"2.297"}],
        [{v:"[Customers].[Classic Legends Inc.]", f:"Classic Legends Inc."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Trucks and Buses]", f:"Trucks and Buses"},{v:73,f:"73"},{v:8567.689999999999,f:"8.568"}],
        [{v:"[Customers].[Classic Legends Inc.]", f:"Classic Legends Inc."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:233,f:"233"},{v:24922.699999999997,f:"24.923"}],
        [{v:"[Customers].[Clover Collections, Co.]", f:"Clover Collections, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:202,f:"202"},{v:31688.82,f:"31.689"}],
        [{v:"[Customers].[Clover Collections, Co.]", f:"Clover Collections, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Motorcycles]", f:"Motorcycles"},{v:58,f:"58"},{v:4953.200000000001,f:"4.953"}],
        [{v:"[Customers].[Clover Collections, Co.]", f:"Clover Collections, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Planes]", f:"Planes"},{v:115,f:"115"},{v:11784.36,f:"11.784"}],
        [{v:"[Customers].[Clover Collections, Co.]", f:"Clover Collections, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Trains]", f:"Trains"},{v:50,f:"50"},{v:3112.6,f:"3.113"}],
        [{v:"[Customers].[Clover Collections, Co.]", f:"Clover Collections, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Trucks and Buses]", f:"Trucks and Buses"},{v:37,f:"37"},{v:3983.05,f:"3.983"}],
        [{v:"[Customers].[Clover Collections, Co.]", f:"Clover Collections, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:28,f:"28"},{v:2234.4,f:"2.234"}],
        [{v:"[Customers].[Collectable Mini Designs Co.]", f:"Collectable Mini Designs Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:286,f:"286"},{v:31869.82,f:"31.870"}],
        [{v:"[Customers].[Collectable Mini Designs Co.]", f:"Collectable Mini Designs Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Planes]", f:"Planes"},{v:240,f:"240"},{v:20128.19,f:"20.128"}],
        [{v:"[Customers].[Collectable Mini Designs Co.]", f:"Collectable Mini Designs Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Ships]", f:"Ships"},{v:247,f:"247"},{v:21575.89,f:"21.576"}],
        [{v:"[Customers].[Collectable Mini Designs Co.]", f:"Collectable Mini Designs Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:181,f:"181"},{v:13915.32,f:"13.915"}],
        [{v:"[Customers].[Collectables For Less Inc.]", f:"Collectables For Less Inc."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:382,f:"382"},{v:39507.31999999999,f:"39.507"}],
        [{v:"[Customers].[Collectables For Less Inc.]", f:"Collectables For Less Inc."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Planes]", f:"Planes"},{v:113,f:"113"},{v:11202.400000000001,f:"11.202"}],
        [{v:"[Customers].[Collectables For Less Inc.]", f:"Collectables For Less Inc."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Ships]", f:"Ships"},{v:24,f:"24"},{v:2172.48,f:"2.172"}],
        [{v:"[Customers].[Collectables For Less Inc.]", f:"Collectables For Less Inc."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:276,f:"276"},{v:28695.78,f:"28.696"}],
        [{v:"[Customers].[Corporate Gift Ideas Co.]", f:"Corporate Gift Ideas Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:323,f:"323"},{v:44387.06,f:"44.387"}],
        [{v:"[Customers].[Corporate Gift Ideas Co.]", f:"Corporate Gift Ideas Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Motorcycles]", f:"Motorcycles"},{v:369,f:"369"},{v:37444.270000000004,f:"37.444"}],
        [{v:"[Customers].[Corporate Gift Ideas Co.]", f:"Corporate Gift Ideas Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Ships]", f:"Ships"},{v:77,f:"77"},{v:8652.56,f:"8.653"}],
        [{v:"[Customers].[Corporate Gift Ideas Co.]", f:"Corporate Gift Ideas Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Trucks and Buses]", f:"Trucks and Buses"},{v:103,f:"103"},{v:9357.7,f:"9.358"}],
        [{v:"[Customers].[Corporate Gift Ideas Co.]", f:"Corporate Gift Ideas Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:575,f:"575"},{v:50040.90999999999,f:"50.041"}],
        [{v:"[Customers].[Corrida Auto Replicas, Ltd]", f:"Corrida Auto Replicas, Ltd"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:232,f:"232"},{v:25239.36,f:"25.239"}]
    ],

    options: {
        "isMultiValued": true,
        "dataOptions": {
            //"categoriesCount":   3, // auto
            "measuresInColumns": true
        }
    }
};

var steelWheels03 = {
        "metadata":[
            {"colIndex":0, "colName":"[Customers].[Customer]", "colLabel":"Customer",  "colType":"STRING" },
            {"colIndex":1, "colName":"[Markets].[Territory]",  "colLabel":"Territory", "colType":"STRING" },
            {"colIndex":2, "colName":"[Product].[Line]",       "colLabel":"Line",      "colType":"STRING" },
            {"colIndex":3, "colName":"[Measures].[Quantity]",  "colLabel":"Quantity",  "colType":"NUMERIC"}
         ],

         "resultset":[
            [{v:"[Customers].[AV Stores, Co.]", f:"AV Stores, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:628,f:"628"}],
            [{v:"[Customers].[AV Stores, Co.]", f:"AV Stores, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Ships]", f:"Ships"},{v:257,f:"257"}],
            [{v:"[Customers].[AV Stores, Co.]", f:"AV Stores, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Trains]", f:"Trains"},{v:120,f:"120"}],
            [{v:"[Customers].[AV Stores, Co.]", f:"AV Stores, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:773,f:"773"}],
            [{v:"[Customers].[Alpha Cognac]", f:"Alpha Cognac"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:126,f:"126"}],
            [{v:"[Customers].[Alpha Cognac]", f:"Alpha Cognac"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Planes]", f:"Planes"},{v:218,f:"218"}],
            [{v:"[Customers].[Alpha Cognac]", f:"Alpha Cognac"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Ships]", f:"Ships"},{v:247,f:"247"}],
            [{v:"[Customers].[Alpha Cognac]", f:"Alpha Cognac"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:96,f:"96"}],
            [{v:"[Customers].[Amica Models & Co.]", f:"Amica Models & Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:149,f:"149"}],
            [{v:"[Customers].[Amica Models & Co.]", f:"Amica Models & Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Ships]", f:"Ships"},{v:82,f:"82"}],
            [{v:"[Customers].[Amica Models & Co.]", f:"Amica Models & Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Trains]", f:"Trains"},{v:22,f:"22"}],
            [{v:"[Customers].[Amica Models & Co.]", f:"Amica Models & Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Trucks and Buses]", f:"Trucks and Buses"},{v:24,f:"24"}],
            [{v:"[Customers].[Amica Models & Co.]", f:"Amica Models & Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:566,f:"566"}],
            [{v:"[Customers].[Anna's Decorations, Ltd]", f:"Anna's Decorations, Ltd"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:744,f:"744"}],
            [{v:"[Customers].[Anna's Decorations, Ltd]", f:"Anna's Decorations, Ltd"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Motorcycles]", f:"Motorcycles"},{v:219,f:"219"}],
            [{v:"[Customers].[Anna's Decorations, Ltd]", f:"Anna's Decorations, Ltd"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Trucks and Buses]", f:"Trucks and Buses"},{v:286,f:"286"}],
            [{v:"[Customers].[Anna's Decorations, Ltd]", f:"Anna's Decorations, Ltd"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:220,f:"220"}],
            [{v:"[Customers].[Atelier graphique]", f:"Atelier graphique"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:156,f:"156"}],
            [{v:"[Customers].[Atelier graphique]", f:"Atelier graphique"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Motorcycles]", f:"Motorcycles"},{v:71,f:"71"}],
            [{v:"[Customers].[Atelier graphique]", f:"Atelier graphique"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:43,f:"43"}],
            [{v:"[Customers].[Australian Collectables, Ltd]", f:"Australian Collectables, Ltd"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:119,f:"119"}],
            [{v:"[Customers].[Australian Collectables, Ltd]", f:"Australian Collectables, Ltd"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Planes]", f:"Planes"},{v:63,f:"63"}],
            [{v:"[Customers].[Australian Collectables, Ltd]", f:"Australian Collectables, Ltd"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Ships]", f:"Ships"},{v:32,f:"32"}],
            [{v:"[Customers].[Australian Collectables, Ltd]", f:"Australian Collectables, Ltd"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:491,f:"491"}],
            [{v:"[Customers].[Australian Collectors, Co.]", f:"Australian Collectors, Co."},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:451,f:"451"}],
            [{v:"[Customers].[Australian Collectors, Co.]", f:"Australian Collectors, Co."},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Motorcycles]", f:"Motorcycles"},{v:490,f:"490"}],
            [{v:"[Customers].[Australian Collectors, Co.]", f:"Australian Collectors, Co."},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Planes]", f:"Planes"},{v:419,f:"419"},{v:39878.759999999995,f:"39.879"}],
            [{v:"[Customers].[Australian Collectors, Co.]", f:"Australian Collectors, Co."},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Trucks and Buses]", f:"Trucks and Buses"},{v:166,f:"166"}],
            [{v:"[Customers].[Australian Collectors, Co.]", f:"Australian Collectors, Co."},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:400,f:"400"}],
            [{v:"[Customers].[Australian Gift Network, Co]", f:"Australian Gift Network, Co"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:117,f:"117"}],
            [{v:"[Customers].[Australian Gift Network, Co]", f:"Australian Gift Network, Co"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Motorcycles]", f:"Motorcycles"},{v:121,f:"121"}],
            [{v:"[Customers].[Australian Gift Network, Co]", f:"Australian Gift Network, Co"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Planes]", f:"Planes"},{v:88,f:"88"}],
            [{v:"[Customers].[Australian Gift Network, Co]", f:"Australian Gift Network, Co"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Trains]", f:"Trains"},{v:33,f:"33"}],
            [{v:"[Customers].[Australian Gift Network, Co]", f:"Australian Gift Network, Co"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Trucks and Buses]", f:"Trucks and Buses"},{v:91,f:"91"}],
            [{v:"[Customers].[Australian Gift Network, Co]", f:"Australian Gift Network, Co"},{v:"[Markets].[APAC]", f:"APAC"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:95,f:"95"}],
            [{v:"[Customers].[Auto Assoc. & Cie.]", f:"Auto Assoc. & Cie."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:87,f:"87"}],
            [{v:"[Customers].[Auto Assoc. & Cie.]", f:"Auto Assoc. & Cie."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Trucks and Buses]", f:"Trucks and Buses"},{v:164,f:"164"}],
            [{v:"[Customers].[Auto Assoc. & Cie.]", f:"Auto Assoc. & Cie."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:386,f:"386"}],
            [{v:"[Customers].[Auto Canal+ Petit]", f:"Auto Canal+ Petit"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:368,f:"368"}],
            [{v:"[Customers].[Auto Canal+ Petit]", f:"Auto Canal+ Petit"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Motorcycles]", f:"Motorcycles"},{v:633,f:"633"}],
            [{v:"[Customers].[Auto-Moto Classics Inc.]", f:"Auto-Moto Classics Inc."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Planes]", f:"Planes"},{v:120,f:"120"}],
            [{v:"[Customers].[Auto-Moto Classics Inc.]", f:"Auto-Moto Classics Inc."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Ships]", f:"Ships"},{v:63,f:"63"}],
            [{v:"[Customers].[Auto-Moto Classics Inc.]", f:"Auto-Moto Classics Inc."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:104,f:"104"}],
            [{v:"[Customers].[Baane Mini Imports]", f:"Baane Mini Imports"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:267,f:"267"}],
            [{v:"[Customers].[Baane Mini Imports]", f:"Baane Mini Imports"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Motorcycles]", f:"Motorcycles"},{v:212,f:"212"}],
            [{v:"[Customers].[Baane Mini Imports]", f:"Baane Mini Imports"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Trains]", f:"Trains"},{v:72,f:"72"}],
            [{v:"[Customers].[Baane Mini Imports]", f:"Baane Mini Imports"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Trucks and Buses]", f:"Trucks and Buses"},{v:308,f:"308"}],
            [{v:"[Customers].[Baane Mini Imports]", f:"Baane Mini Imports"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:223,f:"223"}],
            [{v:"[Customers].[Bavarian Collectables Imports, Co.]", f:"Bavarian Collectables Imports, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Planes]", f:"Planes"},{v:245,f:"245"}],
            [{v:"[Customers].[Bavarian Collectables Imports, Co.]", f:"Bavarian Collectables Imports, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Ships]", f:"Ships"},{v:55,f:"55"}],
            [{v:"[Customers].[Bavarian Collectables Imports, Co.]", f:"Bavarian Collectables Imports, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:101,f:"101"}],
            [{v:"[Customers].[Blauer See Auto, Co.]", f:"Blauer See Auto, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:466,f:"466"}],
            [{v:"[Customers].[Blauer See Auto, Co.]", f:"Blauer See Auto, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Trains]", f:"Trains"},{v:89,f:"89"}],
            [{v:"[Customers].[Blauer See Auto, Co.]", f:"Blauer See Auto, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Trucks and Buses]", f:"Trucks and Buses"},{v:81,f:"81"}],
            [{v:"[Customers].[Blauer See Auto, Co.]", f:"Blauer See Auto, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:175,f:"175"}],
            [{v:"[Customers].[Boards & Toys Co.]", f:"Boards & Toys Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:35,f:"35"}],
            [{v:"[Customers].[Boards & Toys Co.]", f:"Boards & Toys Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Ships]", f:"Ships"},{v:36,f:"36"}],
            [{v:"[Customers].[Boards & Toys Co.]", f:"Boards & Toys Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:31,f:"31"}],
            [{v:"[Customers].[CAF Imports]", f:"CAF Imports"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:91,f:"91"}],
            [{v:"[Customers].[CAF Imports]", f:"CAF Imports"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Ships]", f:"Ships"},{v:245,f:"245"}],
            [{v:"[Customers].[CAF Imports]", f:"CAF Imports"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Trains]", f:"Trains"},{v:29,f:"29"}],
            [{v:"[Customers].[CAF Imports]", f:"CAF Imports"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:103,f:"103"}],
            [{v:"[Customers].[Cambridge Collectables Co.]", f:"Cambridge Collectables Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:29,f:"29"}],
            [{v:"[Customers].[Cambridge Collectables Co.]", f:"Cambridge Collectables Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Planes]", f:"Planes"},{v:52,f:"52"}],
            [{v:"[Customers].[Cambridge Collectables Co.]", f:"Cambridge Collectables Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Ships]", f:"Ships"},{v:40,f:"40"}],
            [{v:"[Customers].[Cambridge Collectables Co.]", f:"Cambridge Collectables Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Trucks and Buses]", f:"Trucks and Buses"},{v:32,f:"32"}],
            [{v:"[Customers].[Cambridge Collectables Co.]", f:"Cambridge Collectables Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:204,f:"204"}],
            [{v:"[Customers].[Canadian Gift Exchange Network]", f:"Canadian Gift Exchange Network"},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:175,f:"175"}],
            [{v:"[Customers].[Canadian Gift Exchange Network]", f:"Canadian Gift Exchange Network"},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Trucks and Buses]", f:"Trucks and Buses"},{v:351,f:"351"}],
            [{v:"[Customers].[Canadian Gift Exchange Network]", f:"Canadian Gift Exchange Network"},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:177,f:"177"}],
            [{v:"[Customers].[Classic Gift Ideas, Inc]", f:"Classic Gift Ideas, Inc"},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:96,f:"96"}],
            [{v:"[Customers].[Classic Gift Ideas, Inc]", f:"Classic Gift Ideas, Inc"},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Planes]", f:"Planes"},{v:98,f:"98"}],
            [{v:"[Customers].[Classic Gift Ideas, Inc]", f:"Classic Gift Ideas, Inc"},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Ships]", f:"Ships"},{v:65,f:"65"}],
            [{v:"[Customers].[Classic Gift Ideas, Inc]", f:"Classic Gift Ideas, Inc"},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Trucks and Buses]", f:"Trucks and Buses"},{v:132,f:"132"}],
            [{v:"[Customers].[Classic Gift Ideas, Inc]", f:"Classic Gift Ideas, Inc"},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:277,f:"277"}],
            [{v:"[Customers].[Classic Legends Inc.]", f:"Classic Legends Inc."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:219,f:"219"}],
            [{v:"[Customers].[Classic Legends Inc.]", f:"Classic Legends Inc."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Ships]", f:"Ships"},{v:174,f:"174"}],
            [{v:"[Customers].[Classic Legends Inc.]", f:"Classic Legends Inc."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Trains]", f:"Trains"},{v:21,f:"21"}],
            [{v:"[Customers].[Classic Legends Inc.]", f:"Classic Legends Inc."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Trucks and Buses]", f:"Trucks and Buses"},{v:73,f:"73"}],
            [{v:"[Customers].[Classic Legends Inc.]", f:"Classic Legends Inc."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:233,f:"233"}],
            [{v:"[Customers].[Clover Collections, Co.]", f:"Clover Collections, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:202,f:"202"}],
            [{v:"[Customers].[Clover Collections, Co.]", f:"Clover Collections, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Motorcycles]", f:"Motorcycles"},{v:58,f:"58"}],
            [{v:"[Customers].[Clover Collections, Co.]", f:"Clover Collections, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Planes]", f:"Planes"},{v:115,f:"115"}],
            [{v:"[Customers].[Clover Collections, Co.]", f:"Clover Collections, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Trains]", f:"Trains"},{v:50,f:"50"}],
            [{v:"[Customers].[Clover Collections, Co.]", f:"Clover Collections, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Trucks and Buses]", f:"Trucks and Buses"},{v:37,f:"37"}],
            [{v:"[Customers].[Clover Collections, Co.]", f:"Clover Collections, Co."},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:28,f:"28"}],
            [{v:"[Customers].[Collectable Mini Designs Co.]", f:"Collectable Mini Designs Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:286,f:"286"}],
            [{v:"[Customers].[Collectable Mini Designs Co.]", f:"Collectable Mini Designs Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Planes]", f:"Planes"},{v:240,f:"240"}],
            [{v:"[Customers].[Collectable Mini Designs Co.]", f:"Collectable Mini Designs Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Ships]", f:"Ships"},{v:247,f:"247"}],
            [{v:"[Customers].[Collectable Mini Designs Co.]", f:"Collectable Mini Designs Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:181,f:"181"}],
            [{v:"[Customers].[Collectables For Less Inc.]", f:"Collectables For Less Inc."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:382,f:"382"}],
            [{v:"[Customers].[Collectables For Less Inc.]", f:"Collectables For Less Inc."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Planes]", f:"Planes"},{v:113,f:"113"}],
            [{v:"[Customers].[Collectables For Less Inc.]", f:"Collectables For Less Inc."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Ships]", f:"Ships"},{v:24,f:"24"}],
            [{v:"[Customers].[Collectables For Less Inc.]", f:"Collectables For Less Inc."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:276,f:"276"}],
            [{v:"[Customers].[Corporate Gift Ideas Co.]", f:"Corporate Gift Ideas Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:323,f:"323"}],
            [{v:"[Customers].[Corporate Gift Ideas Co.]", f:"Corporate Gift Ideas Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Motorcycles]", f:"Motorcycles"},{v:369,f:"369"}],
            [{v:"[Customers].[Corporate Gift Ideas Co.]", f:"Corporate Gift Ideas Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Ships]", f:"Ships"},{v:77,f:"77"}],
            [{v:"[Customers].[Corporate Gift Ideas Co.]", f:"Corporate Gift Ideas Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Trucks and Buses]", f:"Trucks and Buses"},{v:103,f:"103"}],
            [{v:"[Customers].[Corporate Gift Ideas Co.]", f:"Corporate Gift Ideas Co."},{v:"[Markets].[NA]", f:"NA"},{v:"[Product].[Vintage Cars]", f:"Vintage Cars"},{v:575,f:"575"}],
            [{v:"[Customers].[Corrida Auto Replicas, Ltd]", f:"Corrida Auto Replicas, Ltd"},{v:"[Markets].[EMEA]", f:"EMEA"},{v:"[Product].[Classic Cars]", f:"Classic Cars"},{v:232,f:"232"}]
        ],

        options: {}
    };


var flare = {
    analytics: {
      cluster: {
        AgglomerativeCluster: 3938,
        CommunityStructure: 3812,
        HierarchicalCluster: 6714,
        MergeEdge: 743
      },
      graph: {
        BetweennessCentrality: 3534,
        LinkDistance: 5731,
        MaxFlowMinCut: 7840,
        ShortestPaths: 5914,
        SpanningTree: 3416
      },
      optimization: {
        AspectRatioBanker: 7074
      }
    },
    animate: {
      Easing: 17010,
      FunctionSequence: 5842,
      interpolate: {
        ArrayInterpolator: 1983,
        ColorInterpolator: 2047,
        DateInterpolator: 1375,
        Interpolator: 8746,
        MatrixInterpolator: 2202,
        NumberInterpolator: 1382,
        ObjectInterpolator: 1629,
        PointInterpolator: 1675,
        RectangleInterpolator: 2042
      },
      ISchedulable: 1041,
      Parallel: 5176,
      Pause: 449,
      Scheduler: 5593,
      Sequence: 5534,
      Transition: 9201,
      Transitioner: 19975,
      TransitionEvent: 1116,
      Tween: 6006
    },
    data: {
      converters: {
        Converters: 721,
        DelimitedTextConverter: 4294,
        GraphMLConverter: 9800,
        IDataConverter: 1314,
        JSONConverter: 2220
      },
      DataField: 1759,
      DataSchema: 2165,
      DataSet: 586,
      DataSource: 3331,
      DataTable: 772,
      DataUtil: 3322
    },
    display: {
      DirtySprite: 8833,
      LineSprite: 1732,
      RectSprite: 3623,
      TextSprite: 10066
    },
    flex: {
      FlareVis: 4116
    },
    physics: {
      DragForce: 1082,
      GravityForce: 1336,
      IForce: 319,
      NBodyForce: 10498,
      Particle: 2822,
      Simulation: 9983,
      Spring: 2213,
      SpringForce: 1681
    },
    query: {
      AggregateExpression: 1616,
      And: 1027,
      Arithmetic: 3891,
      Average: 891,
      BinaryExpression: 2893,
      Comparison: 5103,
      CompositeExpression: 3677,
      Count: 781,
      DateUtil: 4141,
      Distinct: 933,
      Expression: 5130,
      ExpressionIterator: 3617,
      Fn: 3240,
      If: 2732,
      IsA: 2039,
      Literal: 1214,
      Match: 3748,
      Maximum: 843,
      methods: {
        add: 593,
        and: 330,
        average: 287,
        count: 277,
        distinct: 292,
        div: 595,
        eq: 594,
        fn: 460,
        gt: 603,
        gte: 625,
        iff: 748,
        isa: 461,
        lt: 597,
        lte: 619,
        max: 283,
        min: 283,
        mod: 591,
        mul: 603,
        neq: 599,
        not: 386,
        or: 323,
        orderby: 307,
        range: 772,
        select: 296,
        stddev: 363,
        sub: 600,
        sum: 280,
        update: 307,
        variance: 335,
        where: 299,
        xor: 354,
        _: 264
      },
      Minimum: 843,
      Not: 1554,
      Or: 970,
      Query: 13896,
      Range: 1594,
      StringUtil: 4130,
      Sum: 791,
      Variable: 1124,
      Variance: 1876,
      Xor: 1101
    },
    scale: {
      IScaleMap: 2105,
      LinearScale: 1316,
      LogScale: 3151,
      OrdinalScale: 3770,
      QuantileScale: 2435,
      QuantitativeScale: 4839,
      RootScale: 1756,
      Scale: 4268,
      ScaleType: 1821,
      TimeScale: 5833
    },
    util: {
      Arrays: 8258,
      Colors: 10001,
      Dates: 8217,
      Displays: 12555,
      Filter: 2324,
      Geometry: 10993,
      heap: {
        FibonacciHeap: 9354,
        HeapNode: 1233
      },
      IEvaluable: 335,
      IPredicate: 383,
      IValueProxy: 874,
      math: {
        DenseMatrix: 3165,
        IMatrix: 2815,
        SparseMatrix: 3366
      },
      Maths: 17705,
      Orientation: 1486,
      palette: {
        ColorPalette: 6367,
        Palette: 1229,
        ShapePalette: 2059,
        SizePalette: 2291
      },
      Property: 5559,
      Shapes: 19118,
      Sort: 6887,
      Stats: 6557,
      Strings: 22026
    },
    vis: {
      axis: {
        Axes: 1302,
        Axis: 24593,
        AxisGridLine: 652,
        AxisLabel: 636,
        CartesianAxes: 6703
      },
      controls: {
        AnchorControl: 2138,
        ClickControl: 3824,
        Control: 1353,
        ControlList: 4665,
        DragControl: 2649,
        ExpandControl: 2832,
        HoverControl: 4896,
        IControl: 763,
        PanZoomControl: 5222,
        SelectionControl: 7862,
        TooltipControl: 8435
      },
      data: {
        Data: 20544,
        DataList: 19788,
        DataSprite: 10349,
        EdgeSprite: 3301,
        NodeSprite: 19382,
        render: {
          ArrowType: 698,
          EdgeRenderer: 5569,
          IRenderer: 353,
          ShapeRenderer: 2247
        },
        ScaleBinding: 11275,
        Tree: 7147,
        TreeBuilder: 9930
      },
      events: {
        DataEvent: 2313,
        SelectionEvent: 1880,
        TooltipEvent: 1701,
        VisualizationEvent: 1117
      },
      legend: {
        Legend: 20859,
        LegendItem: 4614,
        LegendRange: 10530
      },
      operator: {
        distortion: {
          BifocalDistortion: 4461,
          Distortion: 6314,
          FisheyeDistortion: 3444
        },
        encoder: {
          ColorEncoder: 3179,
          Encoder: 4060,
          PropertyEncoder: 4138,
          ShapeEncoder: 1690,
          SizeEncoder: 1830
        },
        filter: {
          FisheyeTreeFilter: 5219,
          GraphDistanceFilter: 3165,
          VisibilityFilter: 3509
        },
        IOperator: 1286,
        label: {
          Labeler: 9956,
          RadialLabeler: 3899,
          StackedAreaLabeler: 3202
        },
        layout: {
          AxisLayout: 6725,
          BundledEdgeRouter: 3727,
          CircleLayout: 9317,
          CirclePackingLayout: 12003,
          DendrogramLayout: 4853,
          ForceDirectedLayout: 8411,
          IcicleTreeLayout: 4864,
          IndentedTreeLayout: 3174,
          Layout: 7881,
          NodeLinkTreeLayout: 12870,
          PieLayout: 2728,
          RadialTreeLayout: 12348,
          RandomLayout: 870,
          StackedAreaLayout: 9121,
          TreeMapLayout: 9191
        },
        Operator: 2490,
        OperatorList: 5248,
        OperatorSequence: 4190,
        OperatorSwitch: 2581,
        SortOperator: 2023
      },
      Visualization: 16540
    }
  };


  function buildDataset(tree) {

          // Determine number of categories
      var maxDepth = maxDepthRecursive(tree, 0);

      function maxDepthRecursive(node, level) {
          var maxDepth = level;

          if(typeof node !== 'number') {
              var childLevel = level + 1;
              for(var p in node) {
                  maxDepth = Math.max(maxDepth, maxDepthRecursive(node[p], childLevel));
              }
          }

          return maxDepth;
      }


      // Create metadata
      var colCount = maxDepth + 1;
      var metadata = new Array(colCount);
      for(var i = 0 ; i < maxDepth ; i++) {
          metadata[i] = {colIndex: i, colName: "Category" + i, colType: "STRING"};
      }
      metadata[maxDepth] = {colIndex: maxDepth, colName: "Value", colType: "NUMERIC"};

      // Read resultset
      var resultset = [];

      readRowsRecursive(colCount, [], resultset, tree);

      // Create resultset
      function readRowsRecursive(colCount, row, rows, node) {
          if(typeof node === 'object') {
              for(var p in node) {
                  row.push(p);
                  readRowsRecursive(colCount, row, rows, node[p]);
                  row.pop();
              }
          } else {
              var remainingLevels = (colCount - row.length - 1);
              row = row.slice();
              while(remainingLevels--) { row.push(null); }
              row.push(node); // value

                  rows.push(row);
          }
      }

      return { metadata: metadata, resultset: resultset };
  }

